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