Delete All Procedures

Alter Procedure dbo.DeleteAllProcedures

As

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

if @procName <> 'DeleteAllProcedures'

exec('drop procedure ' + @procName)

fetch next from cur into @procName

end

close cur

deallocate cur

Go

Grant Execute On dbo.DeleteAllProcedures To Public

Go

================== Cách 2 ======================

Select 'Drop Procedure ' + name from sys.procedures Where [type] = 'P'

and is_ms_shipped = 0 and [name] not like 'sp[_]%diagram%'

What you'll get is a nice list of "Drop Procedure" statements that you can paste into the query editor window and execute.