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
argtype_decl
Semantics
-
An error will be thrown if the procedure does not exist unless
IF EXISTSis used. Then a notice is issued instead. -
RESTRICTis the default and it will not drop the procedure if any objects depend on it. -
CASCADEwill drop any objects that transitively depend on the procedure.
Examples
DROP PROCEDURE IF EXISTS transfer(integer, integer, dec) CASCADE;