9.18. DROP FUNCTION
Synopsis
- DROP FUNCTION [ IF EXISTS ] qualified_function_name [ ( parameter_type[, ...] ) ]
Description
Drop an existing function.
The optional IF EXISTS
clause causes the NOT_FOUND
errorto be suppressed if the function does not exists.
Each DROP FUNCTION
statement can only drop one functionat a time. If multiple functions are matched by not specifyingthe parameter type list, the query would fail.
Examples
Drop the function example.default.tan(double)
:
- DROP FUNCTION example.default.tan(double)
If only one function exists for example.default.tan
, parameter type list may be omitted:
- DROP FUNCTION example.default.tan
Drop the function example.default.tan(double)
if it exists:
- DROP FUNCTION IF EXISTS example.default.tan(double)