DROP OPERATOR FAMILY(7)                                   SQL Commands                                   DROP OPERATOR FAMILY(7)



NAME
       DROP OPERATOR FAMILY - remove an operator family


SYNOPSIS
       DROP OPERATOR FAMILY [ IF EXISTS ] name USING index_method [ CASCADE | RESTRICT ]


DESCRIPTION
       DROP  OPERATOR  FAMILY  drops an existing operator family.  To execute this command you must be the owner of the operator
       family.

       DROP OPERATOR FAMILY includes dropping any operator classes contained in the family, but it does  not  drop  any  of  the
       operators  or  functions referenced by the family. If there are any indexes depending on operator classes within the fam-
       ily, you will need to specify CASCADE for the drop to complete.

PARAMETERS
       IF EXISTS
              Do not throw an error if the operator family does not exist.  A notice is issued in this case.

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

       index_method
              The name of the index access method the operator family is for.

       CASCADE
              Automatically drop objects that depend on the operator family.

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

EXAMPLES
       Remove the B-tree operator family float_ops:

       DROP OPERATOR FAMILY float_ops USING btree;

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

COMPATIBILITY
       There is no DROP OPERATOR FAMILY statement in the SQL standard.

SEE ALSO
       ALTER  OPERATOR  FAMILY  [alter_operator_family(7)],  CREATE  OPERATOR FAMILY [create_operator_family(7)], ALTER OPERATOR
       CLASS [alter_operator_class(7)], CREATE OPERATOR  CLASS  [create_operator_class(7)],  DROP  OPERATOR  CLASS  [drop_opera-
       tor_class(7)]



SQL - Language Statements                                  2011-09-22                                    DROP OPERATOR FAMILY(7)