Drop the specified index on the specified table.
DROP INDEX index_name ON tbl_name
index_nameis the name of the index you want to drop.
tbl_nameis the name of a table in a MemSQL database.
- This command must be run on the master aggregator node (see Node Requirements for MemSQL Commands ).
- This command will attempt to run as an online operation, but in certain cases cannot. See ALTER TABLE for more information. Operations which must be run offline cannot be run on distributed tables.
CLUSTERED COLUMNSTOREindexes and
FULLTEXTindexes cannot be dropped using
DROP INDEX. If a table having these indexes is dropped, the indexes are deleted automatically.
memsql> DROP INDEX my_index ON my_tbl; Query OK, 0 rows affected (0.71 sec) Records: 0 Duplicates: 0 Warnings: 0