declare @sql varchar(1000)declare @cot intdeclare @i intset @i=1 select @cot =COUNT(*)  from sysobjects WHERE (type = 'U')select @cotwhile @i<=@cotbegin select @sql = 'drop table ' + name  from sysobjects WHERE (type = 'U') ORDER BY 'drop table ' + nameselect @sqlexec(@sql)set @i=@i+1 end

drop table ?

delete ?

truncate table ?