Loading

Dropping Multiple Stored procedures at once in SQL SERVER 2008

Lajapathy Arun

We can drop multiple procedure at a time by comma separating the procedures.

Dropping Single Procedure:

DROP PROCEDURE dbo.uspGetSalesbyMonth

Dropping Mutiple Procedure:

DROP PROCEDURE dbo.uspGetSalesbyMonth, dbo.uspUpdateSalesQuotes, dbo.uspGetSalesByYear;

Thanks for reading :)

3 Comments

Join the conversation! Your thoughts help the community grow.