SHOW INDEXES
On this page
Show the list of indexes associated with a given table.
Syntax
SHOW INDEXES
{FROM | IN} tbl_name
[{FROM | IN} db_name]Remarks
-
tbl_- name of a table in a SingleStore database.name -
db_- name of a SingleStore database.name -
This command must be run on the master aggregator or a child aggregator node (see Node Requirements for SingleStore Commands).
-
Refer to 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. |
|
|
Always blank (not used in SingleStore) |
|
|
Always blank (not used in SingleStore) |
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)Last modified: January 11, 2023