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