使用命令 SHOW TABLEGROUPS 和 SHOW CREATE TABLE 来查看表组信息。
示例:查看表组信息和定义
obclient> show tablegroups;
+-----------------+------------+---------------+
| TABLEGROUP_NAME | TABLE_NAME | DATABASE_NAME |
+-----------------+------------+---------------+
| TPCC_GROUP | CUST | TPCC |
| TPCC_GROUP | DIST | TPCC |
| TPCC_GROUP | HIST | TPCC |
| TPCC_GROUP | NORD | TPCC |
| TPCC_GROUP | ORDL | TPCC |
| TPCC_GROUP | ORDR | TPCC |
| TPCC_GROUP | STOK | TPCC |
| TPCC_GROUP | WARE | TPCC |
| oceanbase | NULL | NULL |
+-----------------+------------+---------------+
9 rows in set (0.02 sec)
obclient> show create tablegroup tpcc_group\G
*************************** 1. row ***************************
TABLEGROUP: TPCC_GROUP
CREATE TABLEGROUP: CREATE TABLEGROUP "TPCC_GROUP" BINDING = FALSE
partition by hash partitions 6
1 row in set (0.00 sec)