Use this statement to remove a function from the database.

Syntax

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

Remarks

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

DROP FUNCTION is prevented when the statement affects an object that is currently being used by another connection.

Permissions

Any user who owns the object, or has DBA authority, can execute the DROP FUNCTION statement.

Side effects

Automatic commit. Clears the Results tab in the Results pane in Interactive SQL.

See also

• CREATE FUNCTION statement (web services)
• ALTER FUNCTION statement

Standards and compatibility

Example

Drop MyFunction from the database. If the function does not exist, an error is returned.

DROP FUNCTION MyFunction;