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
|
|
|