原理就是根据 sysobjects 系统表里面查到每张表名,然后drop掉,同理可以一次性drop所有存储过程
use
数据库
declare @tname varchar (8000 )
set @tname = ''
select @tname = @tname + Name + ' , ' from sysobjects where xtype = ' U '
select @tname = ' drop table ' + left ( @tname , len ( @tname ) - 1 )
exec ( @tname )
declare @tname varchar (8000 )
set @tname = ''
select @tname = @tname + Name + ' , ' from sysobjects where xtype = ' U '
select @tname = ' drop table ' + left ( @tname , len ( @tname ) - 1 )
exec ( @tname )