DROP INDEX

Reference and syntax for the DROP INDEX command.

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

Parameter	Description
<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;