Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt

Use this file to discover all available pages before exploring further.

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;