SHOW INDEXES

Show the list of indexes associated with a given table.

Syntax

SHOW INDEXES
{FROM | IN} tbl_name
[{FROM | IN} db_name]

Remarks

Output

Column

Description

Table

Table name

Non_unique

1 if non-unique, 0 if unique

Key_name

Index (key) name

Seq_in_index

Ordinal position of key column in index

Column_name

Column name (keys can have one or more columns)

Collation

Collation of string column, if applicable

Cardinality

Always NULL (not applicable in SingleStore)

Sub_part

Always NULL (not applicable in SingleStore)

Packed

Always NULL (not applicable in SingleStore)

Null

YES if values in the key column can be NULL, else blank

Index_type

The type of index. If index type is BTREE, then index is a SingleStore skip list. See Index.

Comment

Always blank (not used in SingleStore)

Index_comment

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

Was this article helpful?