2
$PostgreSQL: pgsql/doc/src/sgml/ref/drop_opclass.sgml,v 1.8 2003-11-29 19:51:38 pgsql Exp $
3
PostgreSQL documentation
6
<refentry id="SQL-DROPOPCLASS">
8
<refentrytitle id="SQL-DROPOPCLASS-TITLE">DROP OPERATOR CLASS</refentrytitle>
9
<refmiscinfo>SQL - Language Statements</refmiscinfo>
13
<refname>DROP OPERATOR CLASS</refname>
14
<refpurpose>remove an operator class</refpurpose>
17
<indexterm zone="sql-dropopclass">
18
<primary>DROP OPERATOR CLASS</primary>
23
DROP OPERATOR CLASS <replaceable class="PARAMETER">name</replaceable> USING <replaceable class="PARAMETER">index_method</replaceable> [ CASCADE | RESTRICT ]
28
<title>Description</title>
31
<command>DROP OPERATOR CLASS</command> drops an existing operator class.
32
To execute this command you must be the owner of the operator class.
37
<title>Parameters</title>
41
<term><replaceable class="parameter">name</replaceable></term>
44
The name (optionally schema-qualified) of an existing operator class.
50
<term><replaceable class="parameter">index_method</replaceable></term>
53
The name of the index access method the operator class is for.
59
<term><literal>CASCADE</literal></term>
62
Automatically drop objects that depend on the operator class.
68
<term><literal>RESTRICT</literal></term>
71
Refuse to drop the operator class if any objects depend on it.
80
<title>Examples</title>
83
Remove the B-tree operator class <literal>widget_ops</literal>:
86
DROP OPERATOR CLASS widget_ops USING btree;
89
This command will not succeed if there are any existing indexes
90
that use the operator class. Add <literal>CASCADE</> to drop
91
such indexes along with the operator class.
96
<title>Compatibility</title>
99
There is no <command>DROP OPERATOR CLASS</command> statement in the
105
<title>See Also</title>
107
<simplelist type="inline">
108
<member><xref linkend="sql-alteropclass" endterm="sql-alteropclass-title"></member>
109
<member><xref linkend="sql-createopclass" endterm="sql-createopclass-title"></member>
115
<!-- Keep this comment at the end of the file
120
sgml-minimize-attributes:nil
121
sgml-always-quote-attributes:t
124
sgml-parent-document:nil
125
sgml-default-dtd-file:"../reference.ced"
126
sgml-exposed-tags:nil
127
sgml-local-catalogs:"/usr/lib/sgml/catalog"
128
sgml-local-ecat-files:nil