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

DROP OPERATOR

DROP OPERATOR drops the definition of an operator.

Syntax

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

Description

  • 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

Drop a user-defined operator for text a @@ b:

DROP OPERATOR @@ (text, text);
Parent topic: SQL Syntax