use master
declare @str varchar(max)
set @str=''
select @str=@str+' drop table '+quotename(name,'')+';'
from sysobjects where xtype='U' and category=0 
and CHARINDEX('_single',name)>0
print @str
exec(@str)

--此语句删除系统中所有表明中存在‘_single’的用户表

------解决方案--------------------
探讨

SQL code


use master
declare @str varchar(max)
set @str=''
select @str=@str+' drop table '+quotename(name,'')+';'
from sysobjects where xtype='U' and category=0 
and CHARINDEX('_single',name)……