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;