DROP FUNCTION#
Synopsis#
DROP FUNCTION [ IF EXISTS ] udf_name ( [ [ parameter_name ] data_type [, ...] ] )
Description#
Removes a catalog UDF. The value of udf_name must be fully
qualified with catalog and schema location of the UDF, unless the default UDF storage catalog and schema are
configured.
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 the error to be suppressed if
the function does not exist.
Examples#
The following example removes the meaning_of_life UDF in the default schema
of the example catalog:
DROP FUNCTION example.default.meaning_of_life();
If the UDF uses a input parameter, the type must be added:
DROP FUNCTION multiply_by_two(bigint);
If the default catalog and schema for UDF storage is configured, you can use the following more compact syntax:
DROP FUNCTION meaning_of_life();