Updated on 2024-05-07 GMT+08:00

DROP FUNCTION

Function

Deletes a function.

Precautions

  • If a function involves operations on temporary tables, DROP FUNCTION cannot be used.
  • Only the function owner or a user granted with the DROP permission can run the DROP FUNCTION command. The system administrator has this permission by default.

Syntax

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

Parameter Description

  • IF EXISTS

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

  • function_name

    Specifies the name of the function to be deleted.

    Value range: an existing function name

  • argmode

    Specifies the parameter mode of the function.

  • argname

    Specifies the parameter name of the function.

  • argtype

    Specifies the parameter type of the function.

  • CASCADE | RESTRICT
    • CASCADE: automatically deletes the objects that depend on the function.
    • RESTRICT: refuses to delete the function if any objects depend on it. This is the default action.

Examples

For details, see Examples.

Helpful Links

ALTER FUNCTION and CREATE FUNCTION