e, so     |
|                           | MyISAM values will be inaccurate. In InnoDB,   |
|                           | if shared tablespaces are used, will be NULL,  |
|                           | while buffering can also delay the update, so  |
|                           | the value will differ from the actual time of  |
|                           | the last UPDATE, INSERT or DELETE.             |
+---------------------------+------------------------------------------------+
| Check_time                | Time the table was last checked. Not kept by   |
|                           | all storage engines, in which case will be     |
|                           | NULL.                                          |
+---------------------------+------------------------------------------------+
| Collation                 | Character set and collation.                   |
+---------------------------+------------------------------------------------+
| Checksum                  | Live checksum value, if any.                   |
+---------------------------+------------------------------------------------+
| Create_options            | Extra CREATE TABLE options.                    |
+---------------------------+------------------------------------------------+
| Comment                   | Table comment provided when MariaDB created    |
|                           | the table.                                     |
+---------------------------+------------------------------------------------+
| Max_index_length          | Maximum index length (supported by MyISAM and  |
|                           | Aria tables).                                  |
+---------------------------+------------------------------------------------+
| Temporary                 | Until MariaDB 11.2.0, placeholder to signal    |
|                           | that a table is a temporary table and always   |
|                           | "N", except "Y" for generated                  |
|                           | information_schema tables and NULL for views.  |
|                           | From MariaDB 11.2.0, will also be set to "Y"   |
|                           | for local temporary tables.                    |
+---------------------------+------------------------------------------------+

Similar information can be found in the information_schema.TABLES table as
well as by using mariadb-show:

mariadb-show --status db_name

Views
-----

For views, all columns in SHOW TABLE STATUS are NULL except 'Name' and
'Comment'

Example
-------

show table status\G
*************************** 1. row ***************************
     Name: bus_routes
    Engine: InnoDB
    Version: 10
  Row_format: Dynamic
     Rows: 5
 Avg_row_length: 3276
  Data_length: 16384
Max_data_length: 0
 Index_length: 0
   Data_free: 0
 Auto_increment: NULL
  Create_time: 2017-05-24 11:17:46
  Update_time: NULL
  Check_time: NULL
   Collation: latin1_swedish_ci
   Checksum: NULL
 Create_options: 
    Comment:

URL: https://mariadb.com/kb/en/show-table-status/https://mariadb.com/kb/en/show-table-status/