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
Programming is fun and interesting. As you all know, sometime we programmers stucks in the middle way of coding without getting a solution. Blogs like this will help us to find a path to solve our problems. The contents of this blog are the solutions that I found by myself and from other sources. Sharing such solutions is also interesting. Thank you!
Showing posts with label How to drop all stored procedures at once in SQL Server database. Show all posts
Showing posts with label How to drop all stored procedures at once in SQL Server database. Show all posts
Tuesday, November 4, 2014
How to drop all stored procedures at once in SQL Server database?
Subscribe to:
Posts (Atom)