Information Schema INNODB_SYS_TABLES Table
You are viewing an old version of this article. View
the current version here.
The Information Schema INNODB_SYS_TABLES table contains information about InnoDB tables.
The PROCESS
privilege is required to view the table.
It has the following columns:
Column | Description | Added |
---|---|---|
TABLE_ID | Unique InnoDB table identifier. | |
NAME | Database and table name, or the uppercase InnoDB system table name. | |
FLAG | 0 (InnoDB system table) or 1 (user table). | |
N_COLS | Number of columns in the table. | |
SPACE | Tablespace identifier where the index resides. 0 represents the InnoDB system tablespace, while any other value represents a table created in file-per-table mode (see the innodb_file_per_table system variable). Remains unchanged after a TRUNCATE TABLE statement. | |
FILE_FORMAT | InnoDB file format | MariaDB 10.0 |
ROW_FORMAT | InnoDB storage format | MariaDB 10.0 |
ZIP_PAGE_SIZE | MariaDB 10.0 |
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.