Only Dynamic Server supports this statement, which is an extension to the ANSI/ISO standard for SQL.
>>-DROP OPCLASS--+------------+--opclass--RESTRICT------------->< '- owner-- .-'
| Element | Description | Restrictions | Syntax |
|---|---|---|---|
| opclass | Name of operator class to be dropped | Must have been created by a previous CREATE OPCLASS statement | Identifier |
| owner | Name of opclass owner | Must own the operator class | Owner Name |
You must be the owner of the operator class or have the DBA privilege to use the DROP OPCLASS statement.
The RESTRICT keyword causes DROP OPCLASS to fail if the database contains indexes defined on the operator class that you plan to drop. Therefore, before you drop the operator class, you must use the DROP INDEX statement to drop any dependent indexes.
The following DROP OPCLASS statement drops an operator class called abs_btree_ops:
DROP OPCLASS abs_btree_ops RESTRICT
Related statement: CREATE OPCLASS, DROP INDEX
For information on how to create or extend an operator class, see IBM Informix User-Defined Routines and Data Types Developer's Guide.