# SHOW INDEXES

Show the list of indexes associated with a given table.

## Syntax

```

SHOW INDEXES
{FROM | IN} tbl_name
[{FROM | IN} db_name]

```

## Remarks

* `tbl_name` - name of a table in a SingleStore database.
* `db_name` - name of a SingleStore database.
* This command must be run on the master aggregator or a child aggregator node (see [Node Requirements for SingleStore Commands](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands.md)).
* Refer to the [Permissions Matrix](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/permissions-matrix.md) for the required permissions.

**Output**

| Column          | Description                                                                                                                                                                   |
| --------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `Table`         | Table name                                                                                                                                                                    |
| `Non_unique`    | `1`if non-unique,`0`if unique                                                                                                                                                 |
| `Key_name`      | Index (key) name                                                                                                                                                              |
| `Seq_in_index`  | Ordinal position of key column in index                                                                                                                                       |
| `Column_name`   | Column name (keys can have one or more columns)                                                                                                                               |
| `Collation`     | Collation of string column, if applicable                                                                                                                                     |
| `Cardinality`   | Always`NULL`(not applicable inSingleStore)                                                                                                                                    |
| `Sub_part`      | Always`NULL`(not applicable inSingleStore)                                                                                                                                    |
| `Packed`        | Always`NULL`(not applicable inSingleStore)                                                                                                                                    |
| `Null`          | `YES`if values in the key column can be`NULL`, else blank                                                                                                                     |
| `Index_type`    | The type of index. If index type is`BTREE`, then index is aSingleStoreskip list. See[Index](https://docs.singlestore.com/db/v9.1/create-a-database/other-schema-concepts.md). |
| `Comment`       | Always blank (not used inSingleStore)                                                                                                                                         |
| `Index_comment` | Always blank (not used inSingleStore)                                                                                                                                         |

## Example

```

SHOW INDEXES IN mytbl;
    +-------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
    | Table | Non_unique | Key_name  | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
    +-------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
    | mytbl |          1 | seq       |            1 | seq         | NULL      |        NULL |     NULL | NULL   | YES  | BTREE      |         |               |
    | mytbl |          1 | seq_index |            1 | seq         | NULL      |        NULL |     NULL | NULL   | YES  | BTREE      |         |               |
    +-------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
    2 rows in set (0.00 sec)

```

***

Modified at: January 11, 2023

Source: [/db/v9.1/reference/sql-reference/show-commands/show-indexes/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/show-commands/show-indexes/)

(An index of the documentation is available at /llms.txt)