This documentation has been retired and might not be updated. The products, services, or technologies mentioned in this content are no longer supported. See 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.
Indicates which table names to match. In
* matches any number of characters.