13.5.4.25. 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.
This statement also lists any views in the database. 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.
Note: If you have no
privileges for a table, the table does not show up in the
output from SHOW TABLES or
mysqlshow db_name.
