DROP PROCEDURE

On this page Carat arrow pointing down

New in v23.2: 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

DROP PROCEDURE IF EXISTS proc_name ( routine_param , ) , CASCADE RESTRICT

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:

icon/buttons/copy
DROP PROCEDURE delete_earliest_histories;

See also


Yes No
On this page

Yes No