Updated on 2025-08-25 GMT+08:00

DROP FUNCTION

Function

Deletes an existing function.

Precautions

  • Built-in functions cannot be deleted. Only user-defined functions can be deleted.

Syntax

1
DROP FUNCTION [ IF EXISTS ] function_name;

Parameter Description

Table 1 DROP FUNCTION parameters

Parameter

Description

Value Range

IF EXISTS

Issues a notice instead of throwing an error if the specified external table does not exist.

-

function_name

Name of the function to be deleted.

Existing function name.

Examples

Delete a user-defined function.

1
DROP FUNCTION your_schema.func_add;