Important
New database features are no longer connected to engine versions; features are now enabled independently during scheduled update windows, and “major” and “minor” releases no longer exist in Helios. Please visit the release notes to view the latest features available in your database clusters.
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 Helios database.name -
db_- name of a SingleStore Helios database.name -
Refer to the Permissions Matrix for the required permissions.
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 Helios) |
|
|
Always blank (not used in SingleStore Helios) |
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: