假设表格的名字为***Tab***的字样 可以用如下语句进行批量删除
exec sp_msforeachtable 'if '' ? '' like ''%Tab%'' drop table ?'
或着
declare curname cursor for select from name
from sysobjects where name like %Tab%' and xtype='U'
declare @name nvarchar,@sql varchar(500)
open curname
fetch next from curname into @name
while @@fetch_status=0
begin
set @sql='drop table '+@name
exec(@sql)
fetch next from curname into @name
end
close curname
deallocate curname