DROP FUNCTION#
Synopsis#
DROP FUNCTION [ IF EXISTS ] udf_name ( [ [ parameter_name ] data_type [, ...] ] )
Description#
Removes a catalog UDF. The value of udf_name may be qualified
with galaxy.functions as the catalog and schema location of the UDF, but this
is not required.
The data_types must be included for UDFs that use parameters to ensure the UDF
with the correct name and parameter signature is removed.
The optional IF EXISTS clause causes an error to be suppressed if
the function does not exist.
Examples#
The following example removes the meaning_of_life UDF.
DROP FUNCTION meaning_of_life();
If the UDF uses an input parameter, the type must be added:
DROP FUNCTION multiply_by_two(bigint);
