Syntax:
SHOW TABLE STATUS [FROM db_name] [LIKE 'pattern']

SHOW TABLE STATUS works likes SHOW TABLE, but provides a lot of
information about each table. You can also get this list using the
mysqlshow --status db_name command. This statement was added in MySQL
3.23.
