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

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)

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)

Last modified: June 22, 2022

Was this article helpful?