Switch to: V12V11V10V9V8V7V6V5

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;