SHOW [EXTENDED] [FULL] TABLES
[{FROM | IN} db_name]
[LIKE 'pattern' | WHERE expr]
The SHOW TABLES statement lists all non-TEMPORARY tables in the specified database.
The optional LIKE clause filters table names by pattern. The matching behavior of LIKE depends on the value of the lower_case_table_names system variable setting. The optional WHERE clause allows you to apply more general filter conditions.
The optional EXTENDED keyword lists hidden tables created by failed ALTER TABLE operations, typically starting with #sql. These tables can be dropped using the DROP TABLE statement.
If specified, the FULL modifier adds a second column to the output, indicating the object type: BASE TABLE (for tables), VIEW, or SYSTEM VIEW (for INFORMATION_SCHEMA views). Additional table information is available through the INFORMATION_SCHEMA.TABLES view.
For more information, see the MySQL documentation: SHOW TABLES Statement.