<< Click to Display Table of Contents >> DROP INDEX Command |
![]() ![]() ![]() |
DROP INDEX allows you to remove an existing index.
DROP INDEX [ MEMORY ] table_name.index_name
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;
__________________________