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:

ColumnDescriptionAdded
TABLE_IDUnique InnoDB table identifier.
NAMEDatabase and table name, or the uppercase InnoDB system table name.
FLAG0 (InnoDB system table) or 1 (user table).
N_COLSNumber of columns in the table.
SPACETablespace 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_FORMATInnoDB file formatMariaDB 10.0
ROW_FORMATInnoDB storage formatMariaDB 10.0
ZIP_PAGE_SIZEMariaDB 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.