# DROP INDEX

[Read this page in HTML](https://www.scopedb.io/docs/reference/commands/statements/drop-index)

Removes an index from a table. The table’s rows are retained, but queries can no longer use that index.

## Syntax

```scopeql
DROP INDEX [ IF EXISTS ] <name> ON <table_name>
```

`<name>` identifies the index within the specified table. `IF EXISTS` skips the operation if the index is missing.

## Examples

After running the [`CREATE INDEX` examples](https://www.scopedb.io/docs/reference/commands/statements/create-index.md#examples), remove the event-ID index:

```scopeql
DROP INDEX idx_event_id ON indexed_requests
```

Use `IF EXISTS` when cleanup may run more than once:

```scopeql
DROP INDEX IF EXISTS idx_event_id ON indexed_requests
```