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 SingleStoreDB database.db_name
- name of a SingleStoreDB database.expr
- SQL WHERE clauseThis 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)