T-SQL » Stored Procedures » Deleting a Stored Procedure

Syntax:
DROP PROCEDURE procedure_name, ...
procedure_name
Is the name of the stored procedure or stored procedure group to be removed.

When a stored procedure is no longer needed, it can be deleted using the DROP PROCEDURE command.

Examples

Code:
DROP PROCEDURE spSelectStudent1;
Output:
The command(s) completed successfully.
Explanation:

The above DROP command deletes the stored procedure spSelectStudent1 from the database.

Language(s): MS SQL Server