本文介绍了如何一次删除 SQL Server 数据库中的所有存储过程?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
目前我们为脚本文件中的每个存储过程使用单独的 drop 语句:
Currently we use separate a drop statements for each stored procedure in the script file:
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MySP]')
AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[MySP]
有没有办法一次性删除它们，或者循环删除它们?
Is there a way to drop them all at once, or maybe in a loop?
推荐答案
Something like (Found at 使用 SQL Server 中的存储过程从数据库中删除所有过程).
Something like (Found at Delete All Procedures from a database using a Stored procedure in SQL Server).
顺便说一句，这似乎是一件非常危险的事情，只是一个想法......
Just so by the way, this seems like a VERY dangerous thing to do, just a thought...
declare @procName varchar(500)
declare cur cursor
for select [name] from sys.objects where type = 'p'
open cur
fetch next from cur into @procName
while @@fetch_status = 0
begin
exec('drop procedure [' + @procName + ']')
fetch next from cur into @procName
end
close cur
deallocate cur
这篇关于如何一次删除 SQL Server 数据库中的所有存储过程?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！
本站部分内容来源互联网,如果有图片或者内容侵犯您的权益请联系我们删除！