DROP INDEX¶

Synopsis¶

DROP INDEX name

Synopsis legend

Description¶

A DROP INDEX statement removes an existing secondary index. If the index was not given a name during creation, the index name is <table_name>_<column_name>_idx.

Example¶

DROP INDEX user_state;

DROP INDEX users_zip_idx;