SHOW TABLE METADATA
Description
The SHOW TABLE METADATA syntax is used to query table metadata.
Syntax
ShowTableMetadata ::=
'SHOW' 'TABLE' 'METADATA' tableName (',' tableName)* ('FROM' databaseName)?
tableName ::=
distSQLIdentifier
databaseName ::=
distSQLIdentifier
distSQLIdentifier ::=
identifier | quotedIdentifier
quotedIdentifier ::=
'`' identifier '`' | '"' identifier '"'Return Value Description
| Columns | Description |
|---|---|
| database_name | database name |
| table_name | table name |
| type | metadata type |
| name | metadata name |
| value | metadata value |
Supplement
-
When
databaseNameis not specified, the default is the currently usedDATABASE. IfDATABASEis not used,No database selectedwill be prompted. -
tableNameanddatabaseNamecan be unquoted identifiers, backtick-quoted identifiers, or double-quoted identifiers.
Example
- Query metadata of multiple tables from specified database
SHOW TABLE METADATA t_order, `t_order_1` FROM "sharding_db";mysql> SHOW TABLE METADATA t_order, `t_order_1` FROM "sharding_db";
+---------------+------------+--------+----------+---------------------------+
| database_name | table_name | type | name | value |
+---------------+------------+--------+----------+---------------------------+
| sharding_db | t_order_1 | COLUMN | order_id | {"name":"order_id",...} |
| sharding_db | t_order_1 | COLUMN | user_id | {"name":"user_id",...} |
| sharding_db | t_order_1 | COLUMN | status | {"name":"status",...} |
| sharding_db | t_order_1 | INDEX | PRIMARY | {"name":"PRIMARY",...} |
| sharding_db | t_order | COLUMN | order_id | {"name":"order_id",...} |
| sharding_db | t_order | COLUMN | user_id | {"name":"user_id",...} |
| sharding_db | t_order | COLUMN | status | {"name":"status",...} |
| sharding_db | t_order | INDEX | PRIMARY | {"name":"PRIMARY",...} |
+---------------+------------+--------+----------+---------------------------+
8 rows in set (0.01 sec)- Query metadata of one table from specified database
SHOW TABLE METADATA "t_order" FROM `sharding_db`;mysql> SHOW TABLE METADATA "t_order" FROM `sharding_db`;
+---------------+------------+--------+----------+---------------------------+
| database_name | table_name | type | name | value |
+---------------+------------+--------+----------+---------------------------+
| sharding_db | t_order | COLUMN | order_id | {"name":"order_id",...} |
| sharding_db | t_order | COLUMN | user_id | {"name":"user_id",...} |
| sharding_db | t_order | COLUMN | status | {"name":"status",...} |
| sharding_db | t_order | INDEX | PRIMARY | {"name":"PRIMARY",...} |
+---------------+------------+--------+----------+---------------------------+
4 rows in set (0.00 sec)- Query metadata of multiple tables from current database
SHOW TABLE METADATA `t_order`, "t_order_1";mysql> SHOW TABLE METADATA `t_order`, "t_order_1";
+---------------+------------+--------+----------+---------------------------+
| database_name | table_name | type | name | value |
+---------------+------------+--------+----------+---------------------------+
| sharding_db | t_order_1 | COLUMN | order_id | {"name":"order_id",...} |
| sharding_db | t_order_1 | COLUMN | user_id | {"name":"user_id",...} |
| sharding_db | t_order_1 | COLUMN | status | {"name":"status",...} |
| sharding_db | t_order_1 | INDEX | PRIMARY | {"name":"PRIMARY",...} |
| sharding_db | t_order | COLUMN | order_id | {"name":"order_id",...} |
| sharding_db | t_order | COLUMN | user_id | {"name":"user_id",...} |
| sharding_db | t_order | COLUMN | status | {"name":"status",...} |
| sharding_db | t_order | INDEX | PRIMARY | {"name":"PRIMARY",...} |
+---------------+------------+--------+----------+---------------------------+
8 rows in set (0.00 sec)- Query metadata of one table from current database
SHOW TABLE METADATA "t_order";mysql> SHOW TABLE METADATA "t_order";
+---------------+------------+--------+----------+---------------------------+
| database_name | table_name | type | name | value |
+---------------+------------+--------+----------+---------------------------+
| sharding_db | t_order | COLUMN | order_id | {"name":"order_id",...} |
| sharding_db | t_order | COLUMN | user_id | {"name":"user_id",...} |
| sharding_db | t_order | COLUMN | status | {"name":"status",...} |
| sharding_db | t_order | INDEX | PRIMARY | {"name":"PRIMARY",...} |
+---------------+------------+--------+----------+---------------------------+
4 rows in set (0.01 sec)Reserved word
SHOW, TABLE, METADATA, FROM