DROP PROCEDURE

Synopsis

Use the DROP PROCEDURE statement to remove a procedure from a database.

Syntax

• Grammar
• Diagram

drop_procedure ::= DROP PROCEDURE [ IF EXISTS ]  
                   { name [ ( [ argtype_decl [ , ... ] ] ) ] } 
                   [ , ... ] [ CASCADE | RESTRICT ]
argtype_decl ::= [ argmode ] [ argname ] argtype

drop_procedure

argtype_decl

Semantics

• An error will be thrown if the procedure does not exist unless IF EXISTS is used. Then a notice is issued instead.

• RESTRICT is the default and it will not drop the procedure if any objects depend on it.

• CASCADE will drop any objects that transitively depend on the procedure.

Examples

DROP PROCEDURE IF EXISTS transfer(integer, integer, dec) CASCADE;

See also

• CREATE PROCEDURE
• DROP FUNCTION
• DROP TRIGGER