Show TOC

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


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


  DROP [PUBLIC] FUNCTION <dbfunction_name>


SQL Tutorial, Database Functions


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.


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