删除表 12345678910 use 数据库名称declare @sql varchar(8000)while (select count(*) from sysobjects where type='U')>0beginSELECT @sql='drop table ' + nameFROM sysobjectsWHERE (type = 'U')ORDER BY 'drop table ' + nameexec(@sql) end 删除视图 123456 declare @sql varchar(8000)set @sql=''select @sql[email protected]sql+ ', '+name from sysobjectswhere type= 'V ' and name not in( 'syssegments ', 'sysconstraints ')set @sql= 'drop view '+stuff(@sql, 1, 1, ' ')exec(@sql) 删除存储过程 123456 use 数据库名称declare @tname varchar(8000)set @tname=''select @[email protected] + Name + ',' from sysobjects where xtype='P'select @tname='drop Procedure ' + left(@tname,len(@tname)-1)exec(@tname) 转载自:http://www.ovzxen.com/post-38.html 赞微海报分享
近期评论