Background documentationDROP FUNCTION Statement (drop_function_statement) Locate this document in the navigation structure

 

The DROP-FUNCTION statement (drop_function_statement) deletes a database function.

Structure

Syntax Syntax

  1. <drop_function_statement> ::=
      DROP [PUBLIC] FUNCTION <dbfunction_name>
End of the code.
Examples

SQL Tutorial, Database Functions

Explanation

If a schema is not specified in the database function name, the current schema is implicitly assumed.

The current user must be the owner of the database function or have the DROPIN privilege for the schema to which the database function is assigned.

The metadata of the database function is dropped.

PUBLIC

To drop a database function that was created with the property PUBLIC, you have to use the DROP PUBLIC FUNCTION statement for this function.

More Information

Privileges: Overview