<< Click to Display Table of Contents >> Navigation:  SQL Reference > SQL Commands > DROP INDEX Command

 

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;

__________________________
Absolute SQL Reference - 06 February 2021, Niels Knabe