DROP PROCEDURE
DROP PROCEDURE procedure_name
DROP PROCEDURE [[catalog_name.]schema_name.]procedure_name
Usage
The DROP PROCEDURE statement removes the specified procedure from the database.
Examples
DROP PROCEDURE PROCTEST;
DROP PROCEDURE telecomm_database.technician1.add_new_IP_address;
See also