In addition to creating stored procedures there is also the need to delete stored procedures. This topic shows you how you can delete stored procedures that are no longer needed.
The syntax is very straightforward to drop a stored procedure, here are some examples.
To drop a single stored procedure you use the DROP PROCEDURE or DROP PROC command as follows.
DROP PROCEDURE dbo.uspGetAddress GO -- or DROP PROC dbo.uspGetAddress GO
To drop multiple stored procedures with one command you specify each procedure separated by a comma as shown below.
DROP PROCEDURE dbo.uspGetAddress, dbo.uspInsertAddress, dbo.uspDeleteAddress GO -- or DROP PROC dbo.uspGetAddress, dbo.uspInsertAddress, dbo.uspDeleteAddress GO