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
