DROP PROCEDURE

Synopsis

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

Syntax

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

argtype_decl ::= [ argmode ] [ argname ] argtype

drop_procedure

DROPPROCEDUREIFEXISTS,name(,argtype_decl)CASCADERESTRICT

argtype_decl

argmodeargnameargtype

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