Show Tables
Important
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.
LIKE 'pattern'
Indicates which table names to match. In pattern
, *
matches any number of characters.