SHOW-TABLE-STATUS

Name

SHOW TABLE STATUS

Description

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

grammar:

1. SHOW TABLE STATUS
2. [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

Example

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

1. SHOW TABLE STATUS; 2. View the information of the table whose name contains example under the specified database

1. SHOW TABLE STATUS FROM db LIKE "%example%";

Keywords

1. SHOW, TABLE, STATUS

Best Practice