DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(mysql.info) show-tables

Info Catalog (mysql.info) show-table-status (mysql.info) show (mysql.info) show-triggers
 
 13.5.4.22 `SHOW TABLES' Syntax
 ..............................
 
      SHOW [FULL] 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, this statement also
 lists any 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 for the second column are `BASE TABLE' for a table and
 `VIEW' for a view.
 
 * If you have no privileges for a table, the table does not show
 up in the output from `SHOW TABLES' or `mysqlshow db_name'.
 
Info Catalog (mysql.info) show-table-status (mysql.info) show (mysql.info) show-triggers
automatically generated byinfo2html