Sometime we need to delete the all the stored procedures in particular database .For this use the below script to generate to drop the all the store procedures. After execute this query it will gives script for drop store procedures with schema name.
SELECT
‘DROP PROCEDURE ‘ +SCHEMA_NAME(schema_id)+‘.’+name+”
as ‘CopyThisColumnAndExecuteToDeleteAllProcedures‘
FROM sys.procedures
WHERE [type] = ‘P‘ AND is_ms_shipped = 0
AND [name] NOT LIKE ‘sp[_]%diagram%‘
ORDER BY [name] ASC