Help Center > > Developer Guide> SQL Reference> SQL Syntax> DROP FUNCTION

DROP FUNCTION

Updated at: Mar 13, 2020 GMT+08:00

Function

DROP FUNCTION deletes an existing function.

Precautions

If a function involves operations on temporary tables, the function cannot be deleted by running DROP FUNCTION.

Syntax

1
2
DROP FUNCTION [ IF EXISTS ] function_name 
[ ( [ {[ argmode ] [ argname ] argtype} [, ...] ] ) [ CASCADE | RESTRICT ] ];

Parameter Description

  • IF EXISTS

    Sends a notice instead of an error if the function does not exist.

  • function_name

    Specifies the name of the function to be deleted.

    Value range: An existing function name.

  • argmode

    Specifies the mode of a function parameter.

  • argname

    Specifies the name of a function parameter.

  • argtype

    Specifies the data types of a function parameter.

  • CASCADE | RESTRICT
    • CASCADE: automatically deletes all objects that depend on the function to be deleted (such as operators).
    • RESTRICT: refuses to delete the function if any objects depend on it. This is the default.

Examples

See Examples in CREATE FUNCTION.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel