INNODB_SYS_COLUMNS table provides status
InnoDB table columns,
equivalent to the information from the
SYS_COLUMNS table in the
InnoDB data dictionary.
|An identifier representing the table associated with the column; the
same value from
|The name of each column in each table. These names can be uppercase or
lowercase depending on the
|The ordinal position of the column within the table, starting from 0 and incrementing sequentially. When a column is dropped, the remaining columns are reordered so that the sequence has no gaps.|
|A numeric identifier for the column type. 1 =
|The column length, for example 4 for |
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.