DROP FUNCTION

Syntax

DROP FUNCTION [ IF EXISTS ] qualified_function_name

Description

It is used to delete an existing function that matches the given function name. If no matching function exists, the optional IF EXISTS clause will cause the NOT_FOUND error to be suppressed.

Currently, Java and JDBC functions can be deleted.

Example

• Delete the example.namespace01.date_diff function:

  DROP FUNCTION example.namespace01.date_diff

• Delete the example.namespace01.date_diff function if it exists:

  DROP FUNCTION IF EXISTS example.namespace01.date_diff