Man Pages

drop_operator_family(7) - phpMan drop_operator_family(7) - phpMan

Command: man perldoc info search(apropos)  


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 family, 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_operator_class(7)]



SQL - Language Statements         2014-02-17           DROP OPERATOR FAMILY(7)