DROP FUNCTION

Purpose

Use this statement to delete a user-defined function.

Prerequisites

  • You need either the system privilege USE ANY SCHEMA or the object privilege USAGE on the target schema, or the schema must be owned by you or one of your assigned roles.

  • You need to have the system privilege DROP ANY FUNCTION, or the function must be owned by you or one of your assigned 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;