Using Stored Procedures - Beginning C# 2008 Databases: From Novice to Professional - page 115

1. Replace the query with the following statement in the query window and click
Execute.
Drop procedure sp_Select_Employees_Details
You will see the following message: “Command(s) completed successfully.”
2. Navigate to Object Explorer, expand the Northwind database node, and then
expand the Programmability node. Select the Stored Procedures node, right-click,
and select Refresh. Notice that the procedure sp_Select_Employees_Details has
been deleted, as it is no longer listed in Object Explorer (see Figure 6-11).
Figure 6-11. Deleting a stored procedure
How It Works
SQL Server offers the DROP statement to remove objects. To remove the stored procedure,
you use
drop procedure sp_Select_Employees_Details
In this statement, DROP takes the procedure sp_Select_Employees_Details as its value
and will thus remove it.