How to: Delete Stored Procedures and User-Defined Functions
When you no longer need a stored procedure or user-defined function, you can delete it from the database.
Note
Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. For more information, see Visual Studio Settings.
To delete a stored procedure
In Server Explorer, expand the Stored Procedures folder.
Right-click the stored procedure that you want to delete.
Choose Delete from the shortcut menu.
A message prompts you to confirm the deletion. Choose Yes.
The stored procedure is deleted from the database and Server Explorer.
To delete a user-defined function
In Server Explorer, expand the Functions folder.
Right-click the function that you want to delete.
Choose Delete from the shortcut menu.
A message prompts you to confirm the deletion. Choose Yes.
The user-defined function is deleted from the database and Server Explorer.