• CHECKSUM 

The live checksum value, if any. 

• CREATE_OPTIONS 

Extra options used with CREATE TABLE . 

CREATE_OPTIONS  shows partitioned  for a partitioned table. 

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. 

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. 

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. 

• TABLE_COMMENT 

The comment used when creating the table (or information as to why MySQL could not access the table information). 

## Notes 

•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 . 

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: 

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 ’] 

