- 12.4.5 SHOW Syntax
- 12.4.5.1 SHOW AUTHORS Syntax
- 12.4.5.2 SHOW BINARY LOGS Syntax
- 12.4.5.3 SHOW BINLOG EVENTS Syntax
- 12.4.5.4 SHOW CHARACTER SET Syntax
- 12.4.5.5 SHOW COLLATION Syntax
- 12.4.5.6 SHOW COLUMNS Syntax
- 12.4.5.7 SHOW CONTRIBUTORS Syntax
- 12.4.5.8 SHOW CREATE DATABASE Syntax
- 12.4.5.9 SHOW CREATE EVENT Syntax
- 12.4.5.10 SHOW CREATE FUNCTION Syntax
- 12.4.5.11 SHOW CREATE PROCEDURE Syntax
- 12.4.5.12 SHOW CREATE TABLE Syntax
- 12.4.5.13 SHOW CREATE TRIGGER Syntax
- 12.4.5.14 SHOW CREATE VIEW Syntax
- 12.4.5.15 SHOW DATABASES Syntax
- 12.4.5.16 SHOW ENGINE Syntax
- 12.4.5.17 SHOW ENGINES Syntax
- 12.4.5.18 SHOW ERRORS Syntax
- 12.4.5.19 SHOW EVENTS Syntax
- 12.4.5.20 SHOW FUNCTION CODE Syntax
- 12.4.5.21 SHOW FUNCTION STATUS Syntax
- 12.4.5.22 SHOW GRANTS Syntax
- 12.4.5.23 SHOW INDEX Syntax
- 12.4.5.24 SHOW MASTER STATUS Syntax
- 12.4.5.25 SHOW OPEN TABLES Syntax
- 12.4.5.26 SHOW PLUGINS Syntax
- 12.4.5.27 SHOW PRIVILEGES Syntax
- 12.4.5.28 SHOW PROCEDURE CODE Syntax
- 12.4.5.29 SHOW PROCEDURE STATUS Syntax
- 12.4.5.30 SHOW PROCESSLIST Syntax
- 12.4.5.31 SHOW PROFILE Syntax
- 12.4.5.32 SHOW PROFILES Syntax
- 12.4.5.33 SHOW RELAYLOG EVENTS Syntax
- 12.4.5.34 SHOW SLAVE HOSTS Syntax
- 12.4.5.35 SHOW SLAVE STATUS Syntax
- 12.4.5.36 SHOW STATUS Syntax
- 12.4.5.37 SHOW TABLE STATUS Syntax
- 12.4.5.38 SHOW TABLES Syntax
- 12.4.5.39 SHOW TRIGGERS Syntax
- 12.4.5.40 SHOW VARIABLES Syntax
- 12.4.5.41 SHOW WARNINGS Syntax
SHOW {INDEX | INDEXES | KEYS}
{FROM | IN} tbl_name
[{FROM | IN} db_name]
SHOW INDEX returns table index
information. The format resembles that of the
SQLStatistics call in ODBC. This statement
requires some privilege for any column in the table.
SHOW INDEX returns the following
fields:
-
TableThe name of the table.
-
Non_unique0 if the index cannot contain duplicates, 1 if it can.
-
Key_nameThe name of the index.
-
Seq_in_indexThe column sequence number in the index, starting with 1.
-
Column_nameThe column name.
-
How the column is sorted in the index. In MySQL, this can have values “
A” (Ascending) orNULL(Not sorted). -
An estimate of the number of unique values in the index. This is updated by running
ANALYZE TABLEor myisamchk -a.Cardinalityis counted based on statistics stored as integers, so the value is not necessarily exact even for small tables. The higher the cardinality, the greater the chance that MySQL uses the index when doing joins. -
Sub_partThe number of indexed characters if the column is only partly indexed,
NULLif the entire column is indexed. -
PackedIndicates how the key is packed.
NULLif it is not. -
NullContains
YESif the column may containNULL. If not, the column containsNO.Contains
YESif the column may containNULLvalues and''if not. -
Index_typeThe index method used (
BTREE,FULLTEXT,HASH,RTREE). -
CommentVarious remarks.
-
Index_commentAny comment provided for the index with a
COMMENTattribute when the index was created.
You can use
db_name.tbl_name
as an alternative to the
tbl_name FROM
db_name
SHOW INDEX FROM mytable FROM mydb; SHOW INDEX FROM mydb.mytable;
You can also list a table's indexes with the mysqlshow
-k db_name
tbl_name command.
User Comments
This comment applies to http://dev.mysql.com/doc/refman/5.0/en/show-index.html
The mention of the LIKE keyword has been removed from http://dev.mysql.com/doc/refman/5.1/en/show-index.html. It is probably not a valid keyword for SHOW INDEXES.
Add your own comment.