(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