DROP INDEX

Note: This section describes the DROP INDEX command as it pertains to dropping a Text domain index. For a complete description of the DROP INDEX command, see Oracle8i SQL Reference.

Purpose

Use DROP INDEX to drop a specified Text index.

Syntax

drop index [schema.]index [force];

[force]

Optionally force the index to be dropped.

Examples

The following example drops an index named doc_index in the current user's database schema.

drop index doc_index;

Notes

Use force option when Oracle cannot determine the state of the index, such as when an indexing operation crashes.

Related Topics

ALTER INDEX

CREATE INDEX