SHOW TABLE STATUS

description

This statement is used to view some information about Table.

1. Syntax:

3. SHOW TABLE STATUS
4. [FROM db] [LIKE "pattern"]

6. Explain:

8. 1. This statement is mainly used to be compatible with MySQL grammar. At present, only a small amount of information such as Comment is displayed.

Example

1. 1. View the information of all tables under the current database

3. SHOW TABLE STATUS;

6. 2. View the information of the table whose name contains example in the specified database

8. SHOW TABLE STATUS FROM DB LIKE "% example%";

Keyword

1. SHOW,TABLE,STATUS