Updated on 2024-10-25 GMT+08:00

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.

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