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.|
You must have the
PROCESS privilege to
query this table.
Copyright © 1997, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices