DROP FUNCTION¶
Function¶
Deletes an existing function.
Precautions¶
To delete an overloaded function, you must specify the function's parameter (argument) type. For non-overloaded functions, you can delete them by just specifying the function name.
If a function involves operations on temporary tables, the function cannot be deleted by running DROP FUNCTION.
Syntax¶
DROP FUNCTION [ IF EXISTS ] function_name
[ ( [ {[ argmode ] [ argname ] argtype} [, ...] ] ) [ CASCADE | RESTRICT ] ];
Parameter Description¶
IF EXISTS
Sends a notice instead of an error if the specified function does not exist.
function_name
Specifies the name of the function to be deleted.
Value range: an existing function name.
argmode
Specifies the mode of a function parameter.
argname
Specifies the name of a function parameter.
argtype
Specifies the data type of a function parameter.
CASCADE | RESTRICT
CASCADE: automatically deletes all objects that depend on the function to be deleted (such as operators).
RESTRICT: refuses to delete the function if any objects depend on it. This is the default.
Examples¶
Delete a function named add_two_number:
DROP FUNCTION add_two_number;