SHOW TABLE STATUS

Description

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

grammar:

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

illustrate:

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

Examples

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

   SHOW TABLE STATUS;

2. 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