一句sql删除数据库中的所有表
declare @sql varchar(8000)
select @sql=isnull(@sql+' drop table ','')+'['+name+']'
from (select name from sysobjects where xtype='u')t
exec('drop table '+ @sql)
declare @sql varchar(8000)
select @sql=isnull(@sql+' drop table ','')+'['+name+']'
from (select name from sysobjects where xtype='u')t
exec('drop table '+ @sql)