Help Center/ GaussDB/ Developer Guide(Centralized_V2.0-8.x)/ SQL Reference/ SQL Syntax/ D/ DROP OPERATOR
Updated on 2025-08-19 GMT+08:00
View PDF

DROP OPERATOR

Drops the definition of an operator.

Syntax

DROP OPERATOR [ IF EXISTS ]  name ( { left_type | NONE } , { right_type | NONE } )[ CASCADE | RESTRICT ];

Parameters

  • name

    Name of an existing operator.

  • left_type

    Data type of the left operand for the operator; if there is no left operand, write NONE.

  • right_type

    Data type of the right operand for the operator; if there is no right operand, write NONE.

Examples

See Examples.

Helpful Links

ALTER OPERATOR, CREATE OPERATOR, and CREATE OPERATOR CLASS

Parent topic: D