Spec-Zone .ru
спецификации, руководства, описания, API

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 name Description
INDEX_ID An identifier for the index associated with this key field, using the same value as in INNODB_SYS_INDEXES.INDEX_ID.
NAME The name of the original column from the table, using the same value as in INNODB_SYS_COLUMNS.NAME.
POS The 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 sequencehas no gaps.

Notes: