declare @sql varchar(1000)
declare @cot int
declare @i int
set @i=1 
select @cot =COUNT(*)  from sysobjects WHERE (type = 'U')
select @cot
while @i<=@cot
begin 
select @sql = 'drop table ' + name  from sysobjects WHERE (type = 'U') ORDER BY 'drop table ' + name
select @sql
exec(@sql)
set @i=@i+1 
end 

drop table ?
delete ?
truncate table ?

 

posted on 2016-02-01 14:26  敲代码的  阅读(249)  评论(0编辑  收藏  举报