Important

Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.

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 Helios database.

  • db_name - name of a SingleStore Helios database.

  • expr - SQL WHERE clause

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:

Was this article helpful?