SQL SERVER - Delete all Stored Procedure in database

Remove all User-defined Stored Procedures

go
 -- drop all user defined stored procedures
    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