Deleting a function v17
You can delete a function from the database using DROP FUNCTION
.
DROP FUNCTION [ IF EXISTS ] <name> [ (<parameters>) ] [ CASCADE | RESTRICT ];
Where name
is the name of the function to drop.
Note
Specifying the parameter list is required in EDB Postgres Advanced Server under certain circumstances such as in an overloaded function. Oracle requires that you always omit the parameter list.
Use of
IF EXISTS
,CASCADE
, orRESTRICT
isn't compatible with Oracle databases. See the SQL reference for information on these options.
This example drops the function simple_function
:
DROP FUNCTION simple_function;