Syntax

SHOW TABLE STATUS [FROM db_name]
    [LIKE 'pattern' | WHERE expr]

Description

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.

The LIKE clause, if present on its own, indicates which table names to match. The WHERE and LIKE clauses can be given to select rows using more general conditions, as discussed in Extended SHOW.

Comments

Comments loading...
Loading