title: How to drop all stored procedures at once in SQL Server database?
body: <p>Currently we use separate a drop statements for each stored procedure in the script file:  </p>
  
  <pre><code>IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MySP]')   
    AND type in (N'P', N'PC'))  
  DROP PROCEDURE [dbo].[MySP] 
  </code></pre>
  
  <p>Is there a way to drop them all at once, or maybe in a loop?</p>