INNODB_SYS_COLUMNS table provides status
InnoDB table columns,
equivalent to the information from the
SYS_COLUMNS table in the
InnoDB data dictionary.
Table 21.9 INNODB_SYS_COLUMNS Columns
|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 |
You must have the
PROCESS privilege to
query this table.