• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. SQL Reference
  5. SQL Syntax
  6. DROP FUNCTION

DROP FUNCTION

Function

DROP FUNCTION deletes an existing function.

Precautions

None.

Syntax

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.