如何在特定数据库中一次删除所有存储过程 [英] How to Drop a all Store Procedures at a time in a particular DB

问题描述

我想在特定数据库中删除所有存储过程

I want to delete a all stored procedures at time in a particular database

推荐答案

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

您好，



查看此...



删除所有表，存储过程，视图并触发 [ ^ ]



希望这会对你有所帮助。



干杯

Hi,

Check this ...

Drop all tables, stored procedure, views and triggers[^]

Hope this will help you.

Cheers

这篇关于如何在特定数据库中一次删除所有存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！