USE pubs--如果你删除pubs里的表
declare @tbn nvarchar(50)
IF EXISTS (SELECT name FROM sysobjects
WHERE name <> 'name'AND type = 'u')
select @tbn=name from sysobjects where type='u'
exec('drop table '+@tbn)
GO
declare @tbn nvarchar(50)
IF EXISTS (SELECT name FROM sysobjects
WHERE name <> 'name'AND type = 'u')
select @tbn=name from sysobjects where type='u'
exec('drop table '+@tbn)
GO
SP_MSFOREACHTABLE 'DROP TABLE ?'
use databasenamedeclare @tname varchar(8000)
set @tname=''
select @tname=@tname +'['+Name+']' + ',' from sysobjects where xtype='U' and name !='dtproperties'select @tname='drop table ' + left(@tname,len(@tname)-1)--print @tnameexec(@tname)