SHOW INDEXES
Show the list of indexes associated with a given table.
Syntax
SHOW INDEXES {FROM | IN} tbl_name [{FROM | IN} db_name]
Remarks
tbl_name
- name of a table in a SingleStoreDB database.db_name
- name of a SingleStoreDB database.This command must be run on the master aggregator or a child aggregator node (see Node Requirements for SingleStoreDB Commands).
See the Permission Matrix for the required permission.
Output
Column | Description |
---|---|
| Table name |
|
|
| Index (key) name |
| Ordinal position of key column in index |
| Column name (keys can have one or more columns) |
| Collation of string column, if applicable |
| Always |
| Always |
| Always |
|
|
| The type of index. If index type is |
| Always blank (not used in SingleStoreDB) |
| Always blank (not used in SingleStoreDB) |
Example
SHOW INDEXES 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)