---
title: "DROP OPERATOR"
url: "https://docs.yugabyte.com/stable/api/ysql/the-sql-language/statements/ddl_drop_operator/"
---

# DROP OPERATOR

Use the DROP OPERATOR statement to remove an operator.

## Synopsis

Use the DROP OPERATOR statement to remove an operator.

## Syntax

- [![Grammar Icon](/icons/file-lines.svg)Grammar](#grammar-1)
- [![Diagram Icon](/icons/diagram.svg)Diagram](#diagram-1)

```output.ebnf
drop_operator ::= DROP OPERATOR [ IF EXISTS ] 
                  { operator_name ( operator_signature ) } [ , ... ] 
                  [ CASCADE | RESTRICT ]

operator_signature ::= { left_type | NONE } , { right_type | NONE }
```

#### drop\_operator

DROPOPERATORIFEXISTS,[operator\_name](/stable/api/ysql/syntax_resources/grammar_diagrams#operator-name)([operator\_signature](#operator-signature))CASCADERESTRICT

#### operator\_signature

[left\_type](/stable/api/ysql/syntax_resources/grammar_diagrams#left-type)NONE,[right\_type](/stable/api/ysql/syntax_resources/grammar_diagrams#right-type)NONE

## Semantics

See the semantics of each option in the [PostgreSQL docs](https://www.postgresql.org/docs/15/sql-dropoperator.html "PostgreSQL docs").

## Examples

Basic example.

```plpgsql
yugabyte=# CREATE OPERATOR @#@ (
             rightarg = int8,
             procedure = numeric_fac
           );
yugabyte=# DROP OPERATOR @#@ (NONE, int8);
```

## See also

- [CREATE OPERATOR](/stable/api/ysql/the-sql-language/statements/ddl_create_operator "CREATE OPERATOR")