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

New: 5 December 2005

This topic describes how to delete a stored procedure by using Object Explorer in SQL Server Management Studio.

Important

Deleting a stored procedure can cause dependent objects and scripts to fail when the objects and scripts are not updated to reflect the changes that have been made to the stored procedure. For more information, see How to: View the Dependencies of a Stored Procedure (SQL Server Management Studio).

To delete a stored procedure

In Object Explorer, connect to an instance of SQL Server 2005 Database Engine and then expand that instance.
Expand Databases, expand the database in which the stored procedure belongs, and then expand Programmability.
Expand Stored Procedures, right-click the procedure to remove, and then click Delete.
To view objects that depend on the stored procedure, click Show Dependencies.
Confirm the correct stored procedure is selected, and then click OK.
Remove the stored procedure name from dependent objects and scripts.