DROP FUNCTION

Purpose

Use this statement to delete a user-defined function.

Prerequisite

You need to have the system privilege DROP ANY FUNCTION or the function belongs to the current user or one of the user's roles.

Syntax

drop_function::=

Drop Function

Usage Notes

  • If the optional IF EXISTS clause is specified, then the statement does not throw an exception if the function does not exist.
  • The options RESTRICT or CASCADE are not of much significance in this command. However, they are supported syntactically for compatibility reasons.

Example

DROP FUNCTION my_function;