显示表Show Tables

SHOW TABLES [FROM | IN] db_name [LIKE 'pattern']

返回所有表。Return all tables. 显示表的数据库以及表是否是临时表。Shows a table’s database and whether a table is temporary.

FROM | IN

返回数据库中的所有表。Return all tables in a database.

LIKE 'pattern'

指示要匹配的表名称。Indicates which table names to match. pattern 中,* 匹配任意数量的字符。In pattern, * matches any number of characters.