Table of Contents
SHOW INDEXES
[NEW in v5.0]
SHOW INDEXES displays information about all INDEXES of a table.
Syntax
SHOW INDEXES {FROM|OF} table_name [{FROM|OF} db_name]
Result Columns
- fld_name
The name of the INDEX.
- fld_type
The type of index. One of { Inverted, BTree, Hash }
Examples
SHOW INDEXES FROM tblPerson; SHOW INDEXES FROM tblPerson FROM dbAccounting;