DROP PROCEDURE
This statement removes one or more stored procedures from the current database.
Syntax
DROP PROCEDURE procedure-name
Examples
The following statement drops the stored procedure myproc from the dictionary:
DROP PROCEDURE myproc
See Also
CREATE PROCEDURE