批量删除类似名字的表,支持通配符
exec sp_msforeachtable @whereand = "and o.name like ' tb_name %'" , @command1 = "drop table ?"