Deleting Stored Procedures

You can delete a stored procedure when you no longer need it. If a stored procedure that has been deleted is called by another stored procedure, Microsoft SQL Server displays an error message when the calling procedure is executed. However, if a new stored procedure of the same name and the same parameters is defined to replace the one that was deleted, other procedures that reference it will still execute successfully. For example, if stored procedure proc1 references stored procedure proc2, and proc2 is deleted and a different stored procedure called proc2 is created, proc1 now references the new stored procedure. proc1 does not have to be recreated.

To delete a stored procedure

• DROP PROCEDURE (Transact-SQL)

• How to: Delete a Stored Procedure (SQL Server Management Studio)

To delete an extended stored procedure

• sp_dropextendedproc (Transact-SQL)

See Also

Concepts

Creating Stored Procedures (Database Engine)

Creating CLR Stored Procedures

Deferred Name Resolution and Compilation

Executing Stored Procedures (Database Engine)

Recompiling Stored Procedures

Modifying Stored Procedures

Viewing Stored Procedures