| Below code will helps to delete all the store procedure from database:-
declare @procName sysname
declare someCursor cursor for
select name from sysobjects where type = 'P' and objectproperty(id, 'IsMSShipped') = 0
open delCursor
fetch next from delCursor into @procName
while @@FETCH_STATUS = 0
begin
exec('drop proc [' + @procName + ']')
fetch next from delCursor into @procName
end
close delCursor
deallocate delCursor
go | | |