Dropping a user-defined function (SQL)

User-defined functions remain in the database until they are explicitly removed.

Prérequis

You must be the owner of the user-defined function or have one of the following system privileges:

Connect to the database.
Execute a DROP FUNCTION statement similar to the following:
DROP FUNCTION function-name;

Résultat

The user-defined function is dropped.

Exemple

The following statement removes the function FullName from the database:

DROP FUNCTION FullName;