declare @sql varchar(8000)
set @sql=''
select @sql=@sql+','+name from sysobjects where type='U' and name like 'temp%'
set @sql='drop table '+stuff(@sql,1,1,'') --去掉开头一个","
exec(@sql)
--例如:print @sql =drop table dtproperties,Card,ta,codetable,test,Dept,ABC
--以上例子可以扩展到删除所有用户表:)