SHOW TABLE STATUS
Descriptionβ
This statement is used to view some of the information in Table.
Syntax:
SHOW TABLE STATUS
[FROM db] [LIKE "pattern"]
Note
This statement is mainly compatible with MySQL syntax. At present, it only shows a few information, such as Comment.
Examplesβ
-
View all the information of tables under the current database.
SHOW TABLE STATUS;
-
View all the information of tables whose names contain example and who are under specified databases.
SHOW TABLE STATUS FROM db LIKE "%example%";