DROP PROCEDURE

The DROP PROCEDURE drops a .

Required privileges

To drop a procedure, the user must be the owner of 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 :

DROP PROCEDURE delete_earliest_histories;

See also