docs/sql-manual/sql-statements/Show-Statements/SHOW-TABLE-STATUS.md

{ “title”: “SHOW-TABLE-STATUS”, “language”: “en” }

SHOW-TABLE-STATUS

Name

SHOW TABLE STATUS

Description

This statement is used to view some information about the Table.

grammar:

SHOW TABLE STATUS
[FROM db] [LIKE "pattern"]

illustrate:

This statement is mainly used to be compatible with MySQL syntax, currently only a small amount of information such as Comment is displayed

Example

View the information of all tables under the current database
```
SHOW TABLE STATUS;
```
View the information of the table whose name contains example under the specified database
```
SHOW TABLE STATUS FROM db LIKE "%example%";
```

Keywords

SHOW, TABLE, STATUS

Best Practice