批量删除表-sql

 

select 'drop table '+table_name+';'

from information_schema.tables;

 

select 'drop table '+name+';'

from sysobjects

where xtype='U'

 

declare @name varchar(20)

while(exists(select * from sysobjects where xtype='U'))

begin

select @name=name from sysobjects where xtype='U'

exec ('drop table '+@name)

end