DROP INDEX

Deletes an index.

Syntax

-- Drop a regular index
DROP INDEX [IF EXISTS] <index_name>

-- Drop an aggregating index  
DROP AGGREGATING INDEX [IF EXISTS] <index_name>

Parameter	Description
`<index_name>`	The name of the index to be deleted.

DROP INDEX my_index;

DROP AGGREGATING INDEX my_agg_index;

⌘I