SHOW KEYS
On this page
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 of a table in a SingleStoreDB database.name -
db_
- name of a SingleStoreDB database.name -
expr
- SQL WHERE clause -
This command must be run on the master aggregator or a child aggregator node (see Node Requirements for SingleStoreDB Commands).
Output
Column |
Description |
---|---|
|
Table name |
|
Non-unique |
|
Key name |
|
Sequence in the index |
|
Column name |
|
Collation |
|
Cardinality |
|
Sub-part |
|
Packed |
|
Null |
|
Index type (see 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