(mysql.info.gz) SHOW TABLES

 
 13.5.4.18 `SHOW TABLES' Syntax
 ..............................
 
      SHOW [FULL|OPEN] TABLES [FROM DB_NAME] [LIKE 'PATTERN']
 
 `SHOW TABLES' lists the non-`TEMPORARY' tables in a given database.
 You can also get this list using the `mysqlshow DB_NAME' command.
 
 Before MySQL 5.0.1, the output from `SHOW TABLES' contains a single
 column of table names.  Beginning with MySQL 5.0.1, also lists the
 views in the database. As of MySQL 5.0.2, the `FULL' modifier is
 supported such that `SHOW FULL TABLES' displays a second output column.
 Values in the second column are `BASE TABLE' for a table and `VIEW'
 for a view.
 
 * If you have no privileges for a table, the table will not show
 up in the output from `SHOW TABLES' or `mysqlshow db_name'.
 
 `SHOW OPEN TABLES' lists the tables that are currently open in the
 table cache.  Table cache.  The `Comment' field in the output
 tells how many times the table is `cached' and `in_use'.  `OPEN' can be
 used from MySQL 3.23.33 on.

Info Catalog

(mysql.info.gz) SHOW TABLE STATUS

(mysql.info.gz) SHOW

(mysql.info.gz) SHOW VARIABLES

automatically generated byinfo2html