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

SHOW TABLE STATUS works likes SHOW TABLES, but provides a lot of
information about each table. You can also get this list using the
mysqlshow --status db_name command.

URL: http://dev.mysql.com/doc/refman/5.0/en/show-table-status.html

