DROP FUNCTION deletes a UDF.
UDFs and their use in SESAM/SQL are described in detail in chapter "Routines".
You can ascertain which routines are defined and which routines use each other in the views for routines of the INFORMATION_SCHEMA (see chapter "Information schemas").
When a UDF is deleted, the EXECUTE privilege for this UDF is revoked from the current authorization identifier. EXECUTE privileges which have been passed on are also revoked.
The current authorization identifier must own the schema to which the UDF belongs.
DROP FUNCTION udf { CASCADE | RESTRICT }
udf ::= routine
udf
Name of the UDF. You can qualify the unqualified UDF name with a database and schema name.
CASCADE
The UDF udf and each routine which udf calls directly or indirectly are deleted. Views which udf uses directly or indirectly are also deleted.
RESTRICT
The UDF udf can be deleted only if udf is used by no other routine and by no view.
See also
CREATE FUNCTION, CREATE PROCEDURE