1.
sp_msforeachtable "drop table ?"
如果sql server区分大小写,注意
sp_MSforeachtable @command1="drop table ?"
2.
declare @str nvarchar(4000)set @str = ''select @str= @str+name+',' from sysobjects where xtype='U'set @str = 'drop table ' + @strset @str = substring(@str,0,len(@str)) exec( @str)go