Oracle7 Server SQL Reference
DROP INDEX
Purpose
To remove an index from the database.
Prerequisites
The index must be in your own schema or you must have DROP ANY INDEX system privilege.
If you are using Trusted Oracle7 in DBMS MAC mode, your DBMS label must match the index's creation label or you must satisfy one of the following criteria:
- If the index's creation label is higher than your DBMS label, you must have READUP and WRITEUP system privileges
- If the index's creation label is lower than your DBMS label, you must have WRITEDOWN system privilege.
- If the index's creation label and your DBMS label are not comparable, you must have READUP, WRITEUP, and WRITEDOWN system privileges.
Syntax
Keywords and Parameters
schema is the schema containing the index. If you omit schema, Oracle7 assumes the index is in your own schema.
index
is the name of the index to be dropped.
Usage Notes
When the index is dropped all data blocks allocated to the index are returned to the index's tablespace.
Example
This command drops an index named MONOLITH:
DROP INDEX monolith
Related Topics
ALTER INDEX command
CREATE INDEX command
CREATE TABLE command