DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH
 

(mysql.info.gz) SHOW TABLE STATUS

Info Catalog (mysql.info.gz) SHOW STATUS (mysql.info.gz) SHOW (mysql.info.gz) SHOW TABLES
 
 13.5.4.17 `SHOW TABLE STATUS' Syntax
 ....................................
 
      SHOW TABLE STATUS [FROM DB_NAME] [LIKE 'PATTERN']
 
 `SHOW TABLE STATUS' works likes `SHOW TABLE', but provides a lot of
 information about each table. You can also get this list using the
 `mysqlshow --status DB_NAME' command.  This statement was added in
 MySQL 3.23.  As of MySQL 5.0.1, it also displays information about
 views.
 
 `SHOW TABLE STATUS' returns the following fields:
 
 `Name'
      The name of the table.
 
 `Engine'
      The storage engine for the table.  Before MySQL 4.1.2, this value
      is labeled as `Type'.   Storage engines.
 
 `Version'
      The version number of the table's `.frm' file.
 
 `Row_format'
      The row storage format (`Fixed', `Dynamic', `Compressed',
      `Redundant', `Compact').  Starting with MySQL/InnoDB 5.0.3, the
      format of InnoDB tables is reported as `Redundant' or `Compact'.
      Before 5.0.3, InnoDB tables are always in the `Redundant' format.
 
 `Rows'
      The number of rows.  Some storage engines, such as `MyISAM' and
      `ISAM', store the exact count.
 
      For other storage engines, such as `InnoDB', this value is an
      approximation, and may vary from the actual value by as much as 40
      to 50%. In such cases, use `SELECT COUNT(*)' to obtain an accurate
      count.
 
 `Avg_row_length'
      The average row length.
 
 `Data_length'
      The length of the data file.
 
 `Max_data_length'
      The maximum length of the data file.  For fixed-row formats, this
      is the maximum number of rows in the table.  For dynamic-row
      formats, this is the total number of data bytes that can be stored
      in the table, given the data pointer size used.
 
 `Index_length'
      The length of the index file.
 
 `Data_free'
      The number of allocated but unused bytes.
 
 `Auto_increment'
      The next `AUTO_INCREMENT' value.
 
 `Create_time'
      When the table was created.
 
 `Update_time'
      When the data file was last updated.
 
 `Check_time'
      When the table was last checked.
 
 `Collation'
      The table's character set and collation. (New in 4.1.1)
 
 `Checksum'
      The live checksum value (if any). (New in 4.1.1)
 
 `Create_options'
      Extra options used with `CREATE TABLE'.
 
 `Comment'
      The comment used when creating the table (or some information why
      MySQL couldn't access the table information).
 
 
 In the table comment, `InnoDB' tables will report the free space of the
 tablespace to which the table belongs.  For a table located in the
 shared tablespace, this is the free space of the shared tablespace. If
 you are using multiple tablespaces and the table has its own tablespace,
 the freespace is for just that table.
 
 For `MEMORY' (`HEAP') 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, all the fields displayed by `SHOW TABLE STATUS' are `NULL'
 except that `Name' indicates the view name and `Comment' says `view'.
 
Info Catalog (mysql.info.gz) SHOW STATUS (mysql.info.gz) SHOW (mysql.info.gz) SHOW TABLES
automatically generated byinfo2html