• Comment 

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

## Notes 

•For InnoDB  tables, SHOW TABLE STATUS  does not give accurate statistics except for the physical size reserved by the table. The row count is only a rough estimate used in SQL optimization. 

•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 columns displayed by SHOW TABLE STATUS  are 0 or NULL  except that Name  indicates the view name, Create_time  indicates the creation time, and Comment  says VIEW . 

Table information is also available from the INFORMATION_SCHEMA TABLES  table. See Section 26.3.38, “The INFORMATION_SCHEMA TABLES Table” . 

## 13.7.7.39 SHOW TABLES Statement 

SHOW [EXTENDED] [FULL] TABLES [{FROM | IN} db_name ] [LIKE ’ pattern ’ | WHERE expr ] 

SHOW TABLES  lists the non- TEMPORARY  tables in a given database. You can also get this list using the mysqlshow db_name  command. The LIKE  clause, if present, indicates which table names to match. The WHERE  clause can be given to select rows using more general conditions, as discussed in Section 26.8, “Extensions to SHOW Statements” . 

Matching performed by the LIKE  clause is dependent on the setting of the lower_case_table_names system variable. 

The optional EXTENDED  modifier causes SHOW TABLES  to list hidden tables created by failed ALTER TABLE  statements. These temporary tables have names beginning with #sql  and can be dropped using DROP TABLE . 

This statement also lists any views in the database. The optional FULL  modifier causes SHOW TABLES  to display a second output column with values of BASE TABLE  for a table, VIEW  for a view, or SYSTEM VIEW for an INFORMATION_SCHEMA  table. 

If you have no privileges for a base table or view, it does not show up in the output from SHOW TABLES  or mysqlshow db_name . 

Table information is also available from the INFORMATION_SCHEMA TABLES  table. See Section 26.3.38, “The INFORMATION_SCHEMA TABLES Table” . 

## 13.7.7.40 SHOW TRIGGERS Statement 

