Extending Informix-Universal Server: Data Types
Chapter 4: Extending an Operator Class
Home
Contents
Index
Master Index
New Book
Dropping an Operator Class
The
DROP OPCLASS
statement removes the definition for an operator class from the database. Universal Server removes the operator-class definition from the
sysopclasses
system catalog table. You must be the owner of the operator class or the
DBA
to drop its definition from the database.
You must remove all dependent objects before you can drop the operator class. For example, suppose you have created a new operator class called
abs_btree_ops
for the generic B-tree index. (For more information on how to create this operator class, see
"Defining a New B-Tree Operator Class"
.) To drop the
abs_btree_ops
operator class from the database, you must first ensure that:
you are the owner (the person who created the operator class) or the
DBA
.
no indexes are currently defined that use the
abs_btree_ops
operator class.
If such indexes exist, you must first remove them from the database.
Once the preceding conditions are met, the following statement removes the definition of
abs_btree_ops
from the database:
DROP OPCLASS abs_btree_ops RESTRICT
The
RESTRICT
keyword is required in the
DROP OPCLASS
syntax.
Extending Informix-Universal Server: Data Types
, version 9.1
Copyright © 1998, Informix Software, Inc. All rights reserved.
