> ## Documentation Index
> Fetch the complete documentation index at: https://docs.regatta.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# SHOW INDEXES

This view has a single row for each index in the database. The output is ordered by the
(`table_name,index_name`) columns.

Data can be filtered with `IN TABLE` table\_name syntax.

Note, this view contains both indexes created explicitly by the user and indexes created implicitly for `PRIMARY
KEY` and `UNIQUE` and `REFERENCES` constraints.

The following table lists the output’s columns:

| Column name       | Data type     | Description                                                                                                                                                                                                                                |
| ----------------- | ------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| TABLE\_NAME       | VARCHAR(127)  | The table name                                                                                                                                                                                                                             |
| INDEX\_NAME       | VARCHAR(127)  | The index name. This is the filter column.                                                                                                                                                                                                 |
| IS\_UNIQUE        | BOOLEAN       | True if the index is unique. False if not.                                                                                                                                                                                                 |
| COLUMN\_NAME      | VARCHAR(127)  | The index column name                                                                                                                                                                                                                      |
| DEVICES           | VARCHAR(1000) | List of devices on which the index is stored, separated by comma.<br />Note: The output is trimmed after 1000 chars. To see the full list of devices use [SHOW INDEX DEVICES](/sql/system-monitoring/database-catalog/show-index-devices). |
| RANGE\_SEPARATORS | VARCHAR       | Separators of the key ranges of the segments, if any.<br />The column output max size is limited by the [Max SQL statement length](/sql/appendices/database-limitations).                                                                  |