# SHOW KEYS

Show the list of keys associated with a given table.

## Syntax

```

SHOW KEYS
{FROM | IN} tbl_name
[{FROM | IN} db_name]
[WHERE expr]

```

## Remarks

* `tbl_name` - name of a table in a SingleStore database.
* `db_name` - name of a SingleStore database.
* `expr` - SQL WHERE clause
* 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)).

**Output**

| Column          | Description                                                                                              |
| --------------- | -------------------------------------------------------------------------------------------------------- |
| `Table`         | Table name                                                                                               |
| `Non_unique`    | Non-unique                                                                                               |
| `Key_name`      | Key name                                                                                                 |
| `Seq_in_index`  | Sequence in the index                                                                                    |
| `Column_name`   | Column name                                                                                              |
| `Collation`     | Collation                                                                                                |
| `Cardinality`   | Cardinality                                                                                              |
| `Sub_part`      | Sub-part                                                                                                 |
| `Packed`        | Packed                                                                                                   |
| `Null`          | Null                                                                                                     |
| `Index_type`    | Index type (see[Index](https://docs.singlestore.com/db/v9.1/create-a-database/other-schema-concepts.md)) |
| `Comment`       | Comment                                                                                                  |
| `Index_comment` | Comment                                                                                                  |

## Example

```

SHOW KEYS 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: June 22, 2022

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

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