On this page 
The DROP PROCEDURE statement drops a stored procedure.
Required privileges
To drop a procedure, a user must have the DROP privilege on the procedure.
Synopsis
Parameters
| Parameter | Description |
|---|---|
proc_name |
The name of one of more procedures to drop. |
routine_param |
An optional list of the procedure parameters. |
Examples
Drop a stored procedure
The following statement drops the delete_earliest_histories example procedure:
DROP PROCEDURE delete_earliest_histories;
