Delete All Procedures from a database in SQL Server

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.


 ‘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