SHOW TABLE METADATA

Description

The SHOW TABLE METADATA syntax is used to query tabe metadata.

Syntax

Grammar Railroad diagram

  1. ShowTableMetadata ::=
  2.   'SHOW' 'TABLE' 'METADATA' tableName (',' tableName)* ('FROM' databaseName)?
  4. tableName ::=
  5.   identifier
  7. databaseName ::=
  8.   identifier

Return Value Description

ColumnsDescription
schema_namedatabase name
table_nametable name
typemetadata type
namemetadata 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.

Example

  • Query matadata of multiple tables from specified database
  1. SHOW TABLE METADATA t_order, t_order_1 FROM sharding_db;
  1. mysql> SHOW TABLE METADATA t_order, t_order_1 FROM sharding_db;
  2. +-------------------+------------+--------+----------+
  3. | schema_name       | table_name | type   | name     |
  4. +-------------------+------------+--------+----------+
  5. | sharding_db       | t_order_1  | COLUMN | order_id |
  6. | sharding_db       | t_order_1  | COLUMN | user_id  |
  7. | sharding_db       | t_order_1  | COLUMN | status   |
  8. | sharding_db       | t_order_1  | INDEX  | PRIMARY  |
  9. | sharding_db       | t_order    | COLUMN | order_id |
  10. | sharding_db       | t_order    | COLUMN | user_id  |
  11. | sharding_db       | t_order    | COLUMN | status   |
  12. | sharding_db       | t_order    | INDEX  | PRIMARY  |
  13. +-------------------+------------+--------+----------+
  14. 8 rows in set (0.01 sec)
  • Query metadata of one table from specified database
  1. SHOW TABLE METADATA t_order FROM sharding_db;
  1. mysql> SHOW TABLE METADATA t_order FROM sharding_db;
  2. +-------------------+------------+--------+----------+
  3. | schema_name       | table_name | type   | name     |
  4. +-------------------+------------+--------+----------+
  5. | sharding_db       | t_order    | COLUMN | order_id |
  6. | sharding_db       | t_order    | COLUMN | user_id  |
  7. | sharding_db       | t_order    | COLUMN | status   |
  8. | sharding_db       | t_order    | INDEX  | PRIMARY  |
  9. +-------------------+------------+--------+----------+
  10. 4 rows in set (0.00 sec)
  • Query metadata of multiple tables from current database
  1. SHOW TABLE METADATA t_order, t_order_1;
  1. mysql> SHOW TABLE METADATA t_order, t_order_1;
  2. +-------------------+------------+--------+----------+
  3. | schema_name       | table_name | type   | name     |
  4. +-------------------+------------+--------+----------+
  5. | sharding_db       | t_order_1  | COLUMN | order_id |
  6. | sharding_db       | t_order_1  | COLUMN | user_id  |
  7. | sharding_db       | t_order_1  | COLUMN | status   |
  8. | sharding_db       | t_order_1  | INDEX  | PRIMARY  |
  9. | sharding_db       | t_order    | COLUMN | order_id |
  10. | sharding_db       | t_order    | COLUMN | user_id  |
  11. | sharding_db       | t_order    | COLUMN | status   |
  12. | sharding_db       | t_order    | INDEX  | PRIMARY  |
  13. +-------------------+------------+--------+----------+
  14. 8 rows in set (0.00 sec)
  • Query metadata of one table from current database
  1. SHOW TABLE METADATA t_order;
  1. mysql> SHOW TABLE METADATA t_order;
  2. +-------------------+------------+--------+----------+
  3. | schema_name       | table_name | type   | name     |
  4. +-------------+------------+--------+----------+
  5. | sharding_db       | t_order    | COLUMN | order_id |
  6. | sharding_db       | t_order    | COLUMN | user_id  |
  7. | sharding_db       | t_order    | COLUMN | status   |
  8. | sharding_db       | t_order    | INDEX  | PRIMARY  |
  9. +-------------------+------------+--------+----------+
  10. 4 rows in set (0.01 sec)

Reserved word

SHOW, TABLE, METADATA, FROM