INNODB_SYS_FIELDS table provides status
information about the key columns (fields) of
InnoDB indexes, equivalent to the information
SYS_FIELDS table in the
InnoDB data dictionary.
|An identifier for the index associated with this key field, using the
same value as in
|The name of the original column from the table, using the same value as
|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 sequence has no gaps.|
INFORMATION_SCHEMA is a
general-purpose way to monitor the MySQL server, use this
table rather than the corresponding
system table for any new monitoring application you develop.
You must have the
PROCESS privilege to
query this table.