.\" auto-generated by docbook2man-spec $Revision: 1.1.1.1 $

DROP OPERATOR CLASS - Online Linux Manual Page

Section : 7
Updated : 2014-02-17
Source : SQL - Language Statements
Note : SQL Commands
NAMEDROP OPERATOR CLASS − remove an operator class
SYNOPSISDROP OPERATOR CLASS [ IF EXISTS ] name USING index_method [ CASCADE | RESTRICT ]
DESCRIPTIONDROP OPERATOR CLASS drops an existing operator class. To execute this command you must be the owner of the operator class. DROP OPERATOR CLASS does not drop any of the operators or functions referenced by the class. If there are any indexes depending on the operator class, you will need to specify CASCADE for the drop to complete.
PARAMETERSIF EXISTS  Do not throw an error if the operator class does not exist. A notice is issued in this case. 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.
NOTESDROP OPERATOR CLASS will not drop the operator family containing the class, even if there is nothing else left in the family (in particular, in the case where the family was implicitly created by CREATE OPERATOR CLASS). An empty operator family is harmless, but for the sake of tidiness you might wish to remove the family with DROP OPERATOR FAMILY; or perhaps better, use DROP OPERATOR FAMILY in the first place.
EXAMPLESRemove 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.
COMPATIBILITYThere is no DROP OPERATOR CLASS statement in the SQL standard.
SEE ALSOALTER OPERATOR CLASS [alter_operator_class(7)], CREATE OPERATOR CLASS [create_operator_class(7)], DROP OPERATOR FAMILY [drop_operator_family(7)] 0
Johanes Gumabo
Data Size   :   7,955 byte
man-drop_operator_class.7Build   :   2025-03-22, 13:26   :  
Visitor Screen   :   x
Visitor Counter ( page / site )   :   6 / 2,337,618
Visitor ID   :     :  
Visitor IP   :   216.73.216.115   :  
Visitor Provider   :   AMAZON-02   :  
Provider Position ( lat x lon )   :   39.962500 x -83.006100   :   x
Provider Accuracy Radius ( km )   :   20   :  
Provider City   :   Columbus   :  
Provider Province   :   Ohio ,   :   ,
Provider Country   :   United States   :  
Provider Continent   :   North America   :  
Visitor Recorder   :   Version   :  
Visitor Recorder   :   Library   :  
Online Linux Manual Page   :   Version   :   Online Linux Manual Page - Fedora.40 - march=x86-64 - mtune=generic - 25.03.22
Online Linux Manual Page   :   Library   :   lib_c - 24.10.03 - march=x86-64 - mtune=generic - Fedora.40
Online Linux Manual Page   :   Library   :   lib_m - 24.10.03 - march=x86-64 - mtune=generic - Fedora.40
Data Base   :   Version   :   Online Linux Manual Page Database - 24.04.13 - march=x86-64 - mtune=generic - fedora-38
Data Base   :   Library   :   lib_c - 23.02.07 - march=x86-64 - mtune=generic - fedora.36
Very long time ago, I have the best tutor, Wenzel Svojanovsky. If someone knows the email address of Wenzel Svojanovsky, please send an email to johanesgumabo@gmail.com.
Help me, linux0001.com will expire on July 16, 2025. I have no money to renew it. View detail
If error, please print screen and send to johanes_gumabo@yahoo.co.id
Under development. Support me via PayPal.
ERROR : Need New Coding :         (rof_escape_sequence|93|drop_operator_class.7|1|\" auto-generated by docbook2man-spec $Revision: 1.1.1.1 $ |.\\" auto-generated by docbook2man-spec $Revision: 1.1.1.1 $ )         (parse_manual_page_|254|drop_operator_class.7|1|\"|.\\" auto-generated by docbook2man-spec $Revision: 1.1.1.1 $ )