DROP PROCEDURE

New in v23.2: The DROP PROCEDURE drops a .

Required privileges

To drop a procedure, a user must have the DROP 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 :

DROP PROCEDURE delete_earliest_histories;

See also