A numeric value that represents bit-level information about table format and storage characteristics. 

• N_COLS 

The number of columns in the table. The number reported includes three hidden columns that are created by InnoDB  ( DB_ROW_ID , DB_TRX_ID , and DB_ROLL_PTR ). The number reported also includes virtual generated columns, if present. 

• SPACE 

An identifier for the tablespace where the table resides. 0 means the InnoDB  system tablespace. Any other number represents either a file-per-table tablespace or a general tablespace. This identifier stays the same after a TRUNCATE TABLE  statement. For file-per-table tablespaces, this identifier is unique for tables across all databases in the instance. 

• ROW_FORMAT 

The table’s row format ( Compact , Redundant , Dynamic , or Compressed ). 

• ZIP_PAGE_SIZE 

The zip page size. Applies only to tables with a row format of Compressed . 

• SPACE_TYPE 

The type of tablespace to which the table belongs. Possible values include System  for the system tablespace, General  for general tablespaces, and Single  for file-per-table tablespaces. Tables assigned to the system tablespace using CREATE TABLE  or ALTER TABLE TABLESPACE=innodb_system  have a SPACE_TYPE  of General . For more information, see CREATE TABLESPACE . 

• INSTANT_COLS 

The number of columns in the table prior to adding the first instant column using ALTER TABLE ... ADD COLUMN  with ALGORITHM=INSTANT . 

## Example 

mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE TABLE_ID = 214\G *************************** 1. row *************************** TABLE_ID: 214 NAME: test/t1 FLAG: 129 N_COLS: 4 SPACE: 233 ROW_FORMAT: Compact ZIP_PAGE_SIZE: 0 SPACE_TYPE: General  INSTANT_COLS: 0 

## Notes 

•You must have the PROCESS  privilege to query this table. 

•Use the INFORMATION_SCHEMA COLUMNS  table or the SHOW COLUMNS  statement to view additional information about the columns of this table, including data types and default values. 

## 26.4.26 The INFORMATION_SCHEMA INNODB_TABLESPACES Table 

