---
name: "drop_operator_class"
section: "7"
platform: "linux"
package: "postgresql"
version: "7.4.7-6sarge6"
release: "Debian 3.1 (Sarge)"
platforms: ["linux"]
url: "https://new.carta.tech/drop_operator_class"
---

# drop\_operator\_class(7)

remove an operator class

## NAME

DROP OPERATOR CLASS - remove an operator class

## SYNOPSIS

```
DROP OPERATOR CLASS name USING index_method [ CASCADE | RESTRICT ]

```

## DESCRIPTION

**DROP OPERATOR CLASS** drops an existing operator class. To execute this command you must be the owner of the operator class.

## PARAMETERS

- *name*

  The name (optionally schema-qualified) of an existing operator class.

- *index\_method*

  The name of the index access method the operator class is for.

- **CASCADE**

  Automatically drop objects that depend on the operator class.

- **RESTRICT**

  Refuse to drop the operator class if any objects depend on it. This is the default.

## EXAMPLES

Remove the B-tree operator class widget\_ops:

```
DROP OPERATOR CLASS widget_ops USING btree;

```

This command will not succeed if there are any existing indexes that use the operator class. Add CASCADE to drop such indexes along with the operator class.

## COMPATIBILITY

There is no **DROP OPERATOR CLASS** statement in the SQL standard.

## SEE ALSO

ALTER OPERATOR CLASS \[[**alter\_operator\_class**(7)](/alter_operator_class/7.md)\], CREATE OPERATOR CLASS \[**create\_operator\_class**(l)\]