sql 删除所有试图和存储过程

最新推荐文章于 2020-08-11 09:41:40 发布

暖风丶微凉

最新推荐文章于 2020-08-11 09:41:40 发布

阅读量365

点赞数

分类专栏： SQL

本文链接：https://blog.csdn.net/ZeroRm/article/details/105275910

版权

SQL 专栏收录该内容

16 篇文章 1 订阅

订阅专栏

---------------------删除所有的视图------------------- 
use test_databse
GO
declare @sql varchar(8000) 
while (select count(*) from sysobjects where type='V')>0 
begin 
SELECT @sql='drop view ' + name FROM sysobjects WHERE (type = 'V') 
ORDER BY 'drop view ' + name exec(@sql) 
end 

-------------------删除所有的存储过程------------------- 
use test_databse
GO 
declare @sql varchar(8000) 
while (select count(*) from sysobjects where type='P')>0 
begin 
SELECT @sql='drop proc ' + name FROM sysobjects WHERE (type = 'P') 
ORDER BY 'drop table ' + name exec(@sql) 
end