> ## 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.

<AgentInstructions>

## Submitting Feedback

If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback:

POST https://docs.firebolt.io/feedback

```json
{
  "path": "/reference-sql/commands/data-definition/drop-index",
  "feedback": "Description of the issue"
}
```

Only submit feedback when you have something specific and actionable to report.

</AgentInstructions>

> Reference and syntax for the DROP INDEX command.

# DROP INDEX

Deletes an index.

## Syntax

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
-- 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

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
DROP INDEX my_index;
```

### Drop an aggregating index

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
DROP AGGREGATING INDEX my_agg_index;
```