DROP INDEX
Description
This statement is used to drop a specified index on a table. Currently, only bitmap index is supported in this version.
tip
This operation requires the ALTER privilege on the target table. You can follow the instructions in GRANT to grant this privilege.
Syntax:
DROP INDEX index_name ON [db_name.]table_name