SHOW Statements • Comment •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 . 2962 13.7.7.40 SHOW TRIGGERS Statement 13.7.7.39 SHOW TABLES Statement Notes The comment used when creating the table (or information as to why MySQL could not access the table information). Table information is also available from the  INFORMATION_SCHEMA TABLES  table. See Section 26.3.38, “The INFORMATION_SCHEMA TABLES Table” . 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” . SHOW [EXTENDED] [FULL] TABLES [{FROM | IN}  db_name ] [LIKE ’ pattern ’ | WHERE  expr ]