Removes an operator class.
DROP OPERATOR CLASS [IF EXISTS] <name> USING <index_method> [CASCADE | RESTRICT]
DROP OPERATOR drops an existing operator class. To run this command you must be the owner of the operator class.
Remove the B-tree operator class
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.
There is no
DROP OPERATOR CLASS statement in the SQL standard.
Parent topic: SQL Commands