Dropping a user-defined function (SQL)

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

Prerequisites

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

Task

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

The user-defined function is dropped.