Skip to main content
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>

​
Parameters

ParameterDescription
<index_name>The name of the index to be deleted.

​
Examples

​
Drop a regular index

DROP INDEX my_index;

​
Drop an aggregating index

DROP AGGREGATING INDEX my_agg_index;