SHOW TABLE METADATA
语法
补充说明
- 未指定
databaseName
时,默认是当前使用的DATABASE。
如果也未使用DATABASE
则会提示No database selected
。
- 查询指定逻辑库中多个表的元数据
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 | INDEX | PRIMARY |
| sharding_db | t_order | COLUMN | order_id |
| sharding_db | t_order | COLUMN | status |
| sharding_db | t_order | INDEX | PRIMARY |
+-------------------+------------+--------+----------+
8 rows in set (0.01 sec)
- 查询指定逻辑库中单个表的元数据
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)
- 查询当前逻辑库中多个表的元数据
- 查询当前逻辑库中单个表的元数据
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)
保留字
下一篇:熔断