一次删除所有表SQL语句如下:
- declare @tname varchar(8000)
- set @tname=''
- select @tname=@tname + 'drop table sa.'+Name + ';' from sysobjects where xtype='U'
- exec(@tname)
一次删除所有表SQL语句如下:
- declare @tname varchar(8000)
- set @tname=''
- select @tname=@tname + 'drop table sa.'+Name + ';' from sysobjects where xtype='U'
- exec(@tname)
转载于:https://www.cnblogs.com/zhengjuzhuan/archive/2011/01/20/1940178.html