SHOW TABLE STATUS
Description
This statement is used to view some of the information in Table.
tip
This operation does not require privileges.
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%";