The DROP-FUNCTION statement ( drop_function_statement) deletes a database function.
<drop_function_statement>::= DROP [PUBLIC] FUNCTION <dbfunction_name>
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.