Retro Eye care Haitian Deep Dark Default

SHOW TABLE METADATA

Description

The SHOW TABLE METADATA syntax is used to query tabe 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
schema_name database name
table_name table name
type metadata type
name metadata name

Supplement

  • When databaseName is not specified, the default is the currently used DATABASE. If DATABASE is not used, No database selected will be prompted.

  • tableName and databaseName can be unquoted identifiers, backtick-quoted identifiers, or double-quoted identifiers.

Example

  • Query matadata 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";
+-------------------+------------+--------+----------+
| schema_name       | table_name | type   | name     |
+-------------------+------------+--------+----------+
| sharding_db       | t_order_1  | COLUMN | order_id |
| sharding_db       | t_order_1  | COLUMN | user_id  |
| sharding_db       | t_order_1  | COLUMN | status   |
| sharding_db       | t_order_1  | INDEX  | PRIMARY  |
| sharding_db       | t_order    | COLUMN | order_id |
| sharding_db       | t_order    | COLUMN | user_id  |
| sharding_db       | t_order    | COLUMN | status   |
| sharding_db       | t_order    | INDEX  | 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`;
+-------------------+------------+--------+----------+
| schema_name       | table_name | type   | name     |
+-------------------+------------+--------+----------+
| sharding_db       | t_order    | COLUMN | order_id |
| sharding_db       | t_order    | COLUMN | user_id  |
| sharding_db       | t_order    | COLUMN | status   |
| sharding_db       | t_order    | INDEX  | 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";
+-------------------+------------+--------+----------+
| schema_name       | table_name | type   | name     |
+-------------------+------------+--------+----------+
| sharding_db       | t_order_1  | COLUMN | order_id |
| sharding_db       | t_order_1  | COLUMN | user_id  |
| sharding_db       | t_order_1  | COLUMN | status   |
| sharding_db       | t_order_1  | INDEX  | PRIMARY  |
| sharding_db       | t_order    | COLUMN | order_id |
| sharding_db       | t_order    | COLUMN | user_id  |
| sharding_db       | t_order    | COLUMN | status   |
| sharding_db       | t_order    | INDEX  | 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";
+-------------------+------------+--------+----------+
| schema_name       | table_name | type   | name     |
+-------------+------------+--------+----------+
| sharding_db       | t_order    | COLUMN | order_id |
| sharding_db       | t_order    | COLUMN | user_id  |
| sharding_db       | t_order    | COLUMN | status   |
| sharding_db       | t_order    | INDEX  | PRIMARY  |
+-------------------+------------+--------+----------+
4 rows in set (0.01 sec)

Reserved word

SHOW, TABLE, METADATA, FROM