DROP INDEX

Note: This section describes the DROP INDEX statement as it pertains to dropping a Text domain index. For a complete description of the DROP INDEX statement, see Oracle9i 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