The INFORMATION_SCHEMA INNODB_TABLESPACES Table A numeric value that represents bit-level information about table format and storage characteristics. 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. 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. The table’s row format ( Compact ,  Redundant ,  Dynamic , or  Compressed ). The zip page size. Applies only to tables with a row format of  Compressed . 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 . 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 26.4.26 The INFORMATION_SCHEMA INNODB_TABLESPACES 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. •You must have the  PROCESS  privilege to query this table. 4875 • INSTANT_COLS • SPACE_TYPE • ZIP_PAGE_SIZE • ROW_FORMAT • SPACE • N_COLS