删除表
use 数据库名 declare mycur cursor local for select [name] from dbo.sysobjects where xtype='U' declare @name varchar(100) OPEN mycur FETCH NEXT from mycur into @name WHILE @@FETCH_STATUS = 0 BEGIN exec('drop table ' + @name) FETCH NEXT from mycur into @name END CLOSE mycur
删除视图
use 数据库名 declare mycur cursor local for select [name] from dbo.sysobjects where xtype='V' declare @name varchar(100) OPEN mycur FETCH NEXT from mycur into @name WHILE @@FETCH_STATUS = 0 BEGIN exec('drop VIEW ' + @name) FETCH NEXT from mycur into @name END CLOSE mycur
删除存储过程
use eldbs declare mycur cursor local for select [name] from dbo.sysobjects where xtype='P' declare @name varchar(100) OPEN mycur FETCH NEXT from mycur into @name WHILE @@FETCH_STATUS = 0 BEGIN exec('drop PROCEDURE ' + @name) FETCH NEXT from mycur into @name END CLOSE mycur