The INFORMATION_SCHEMA TABLES Table • CHECKSUM • CREATE_OPTIONS • TABLE_COMMENT •For  NDB  tables, the output of this statement shows appropriate values for the  AVG_ROW_LENGTH  and DATA_LENGTH  columns, with the exception that  BLOB  columns are not taken into account. •For  NDB  tables,  DATA_LENGTH  includes data stored in main memory only; the  MAX_DATA_LENGTH  and DATA_FREE  columns apply to Disk Data. •For NDB Cluster Disk Data tables,  MAX_DATA_LENGTH  shows the space allocated for the disk part of a Disk Data table or fragment. (In-memory data resource usage is reported by the  DATA_LENGTH  column.) •For  MEMORY  tables, the  DATA_LENGTH ,  MAX_DATA_LENGTH , and  INDEX_LENGTH  values approximate the actual amount of allocated memory. The allocation algorithm reserves memory in large amounts to reduce the number of allocation operations. •For views, most  TABLES  columns are 0 or  NULL  except that  TABLE_NAME  indicates the view name, CREATE_TIME  indicates the creation time, and  TABLE_COMMENT  says  VIEW . 4829 SELECT TABLE_NAME, ENGINE, VERSION, ROW_FORMAT, TABLE_ROWS, AVG_ROW_LENGTH, DATA_LENGTH, MAX_DATA_LENGTH, INDEX_LENGTH, DATA_FREE, AUTO_INCREMENT, CREATE_TIME, UPDATE_TIME, CHECK_TIME, TABLE_COLLATION, CHECKSUM, CREATE_OPTIONS, TABLE_COMMENT FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = ’ db_name ’ [AND table_name LIKE ’ wild ’] Table information is also available from the  SHOW TABLE STATUS  and  SHOW TABLES  statements. See Section 13.7.7.38, “SHOW TABLE STATUS Statement” , and Section 13.7.7.39, “SHOW TABLES Statement” . The following statements are equivalent: The comment used when creating the table (or information as to why MySQL could not access the table information). When altering the storage engine of a table, table options that are not applicable to the new storage engine are retained in the table definition to enable reverting the table with its previously defined options to the original storage engine, if necessary. The  CREATE_OPTIONS  column may show retained options. When creating a table with strict mode disabled, the storage engine’s default row format is used if the specified row format is not supported. The actual row format of the table is reported in the  ROW_FORMAT column.  CREATE_OPTIONS  shows the row format that was specified in the  CREATE TABLE  statement. Prior to MySQL 8.0.16,  CREATE_OPTIONS  shows the  ENCRYPTION  clause specified for tables created in file-per-table tablespaces. As of MySQL 8.0.16, it shows the encryption clause for file-per-table tablespaces if the table is encrypted or if the specified encryption differs from the schema encryption. The encryption clause is not shown for tables created in general tablespaces. To identify encrypted file- per-table and general tablespaces, query the  INNODB_TABLESPACES ENCRYPTION  column. Extra options used with  CREATE TABLE . CREATE_OPTIONS  shows  partitioned  for a partitioned table. The live checksum value, if any. Notes