Delete all Stored Procedures in a Database

use [Database_name]

declare @procName varchar(500)

declare cur cursor

for Select [name] from sys.procedures where [type] = 'P' and is_ms_shipped = 0 and [name] not like 'sp[_]%diagram%'

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