SHOW KEYS

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)

On this page

Syntax

Remarks

Example

Was this article helpful?

On this page

Was this article helpful?