DROP FUNCTION statement

Removes a function from the database.

Syntax

DROP FUNCTION [ IF EXISTS ] [ owner.]function-name

Remarks

If you do not want an error returned when the DROP FUNCTION statement attempts to remove a function that does not exist, then use the IF EXISTS clause.

Privileges

You must be the owner of the function, or have the DROP ANY PROCEDURE or DROP ANY OBJECT system privilege.

Side effects

Automatic commit.

Standards

ANSI/ISO SQL Standard
Core Feature. The IF EXISTS clause is not in the standard.

Example

This example drops the fictitious function, MyFunction, from the database.

DROP FUNCTION MyFunction;