数据库 批量删除表

select 'drop table '+name+';' from sys.tables where name like 'B111%' 

 

select 'BKM'+SystemNo from b.[dbo].[b] where 'BKM'+SystemNo not in (select name from sys.tables where name like 'BKM%')