DROP FUNCTION

Function

DROP FUNCTION deletes a function.

Precautions

If a function involves operations on temporary tables, DROP FUNCTION cannot be used.

Only the function owner or a user granted with the DROP permission can run the DROP FUNCTION command. The system administrator has this permission by default.

Syntax

1
2

DROP FUNCTION [ IF EXISTS ] function_name 
[ ( [ { [ argname ] [ argmode ] argtype} [, ...] ] ) [ CASCADE | RESTRICT ] ];

Parameter Description

• IF EXISTS

  Reports 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 parameter mode of the function.

• argname

  Specifies the parameter name of the function.

• argtype

  Specifies the parameter type of the function.

• CASCADE | RESTRICT
  • CASCADE: automatically deletes the objects (such as operators) that depend on the function.
  • RESTRICT: refuses to delete the function if any objects depend on it. This is the default action.

Examples

See Examples in CREATE FUNCTION.

Helpful Links

ALTER FUNCTION and CREATE FUNCTION