SHOW TABLE STATUS [FROM db_name] [LIKE 'pattern' | WHERE expr]
SHOW TABLE STATUS works like
SHOW TABLES, but provides a lot of
information about each non-
TEMPORARY table. You can also get
this list using:
mysqlshow --status db_name
See mysqlshow for more details.
The Information Schema TABLES table provides the same information as well.
LIKE clause, if present on its own, indicates which table names to
LIKE clauses can be given to select rows using more general conditions, as discussed in Extended SHOW.