You can execute the DROP INDEX statement to delete an index table. Before you delete an index table, make sure that the ALTER INDEX statement is executed to disable the index table.

Syntax

dropindex_statement ::= drop index [if exists] index_name on table_name;

Examples

drop index idx1 on test;