20.30.10 The INFORMATION_SCHEMA INNODB_SYS_FIELDS Table

The INNODB_SYS_FIELDS table provides status information about the key columns (fields) of InnoDB indexes, equivalent to the information from the SYS_FIELDS table in the InnoDB data dictionary.

Table 20.10 INNODB_SYS_FIELDS Columns

Column nameDescription
INDEX_IDAn identifier for the index associated with this key field, using the same value as in INNODB_SYS_INDEXES.INDEX_ID.
NAMEThe name of the original column from the table, using the same value as in INNODB_SYS_COLUMNS.NAME.
POSThe ordinal position of the key field within the index, starting from 0 and incrementing sequentially. When a column is dropped, the remaining columns are reordered so that the sequence has no gaps.

Notes: