Syntax:
SHOW [EXTENDED] [FULL] TABLES
    [{FROM | IN} db_name]
    [LIKE 'pattern' | WHERE expr]

SHOW TABLES lists the non-TEMPORARY tables in a given database. You can
also get this list using the mysqlshow db_name command. The LIKE
clause, if present, indicates which table names to match. The WHERE
clause can be given to select rows using more general conditions, as
discussed in
https://dev.mysql.com/doc/refman/8.4/en/extended-show.html.

Matching performed by the LIKE clause is dependent on the setting of
the lower_case_table_names system variable.

The optional EXTENDED modifier causes SHOW TABLES to list hidden tables
created by failed ALTER TABLE statements. These temporary tables have
names beginning with #sql and can be dropped using DROP TABLE.

This statement also lists any views in the database. The optional FULL
modifier causes SHOW TABLES to display a second output column with
values of BASE TABLE for a table, VIEW for a view, or SYSTEM VIEW for
an INFORMATION_SCHEMA table.

If you have no privileges for a base table or view, it does not show up
in the output from SHOW TABLES or mysqlshow db_name.

URL: https://dev.mysql.com/doc/refman/8.4/en/show-tables.html

