Syntax:
SHOW TABLES [FROM db_name] [LIKE 'pattern']

SHOW TABLES lists the non-TEMPORARY tables in a given database. You can
also get this list using the mysqlshow db_name command.

The output from SHOW TABLES contains a single column of table names.
