DROP INDEX Command

Previous  Top  Next

DROP INDEX allows you to remove an existing index.

Syntax

DROP INDEX [ MEMORY ] table_name.index_name

Description

DROP INDEX removes an index.

MEMORY

If MEMORY keyword is specified before the table_name then an in-memory table is referenced, not a disk one.

table_name

The name of the table containing index.

index_name

The name of the index to remove.

Example:

DROP INDEX developers.idxUniqueName