DROP PROCEDURE name;
DROP PROCEDURE is used to drop a stand-alone stored procedure in SPL
the name of the procedure to be dropped.
To create a stored procedure use the CREATE PROCEDURE command.
The following drops the simple_procedure stored procedure that we created in the CREATE PROCEDURE section:
DROP PROCEDURE simple_procedure;