使用命令 SHOW TABLEGROUPS 和 SHOW CREATE TABLE 来查看表组信息。

    示例:查看表组信息和定义

    1. obclient> show tablegroups;
    2. +-----------------+------------+---------------+
    3. | TABLEGROUP_NAME | TABLE_NAME | DATABASE_NAME |
    4. +-----------------+------------+---------------+
    5. | TPCC_GROUP | CUST | TPCC |
    6. | TPCC_GROUP | DIST | TPCC |
    7. | TPCC_GROUP | HIST | TPCC |
    8. | TPCC_GROUP | NORD | TPCC |
    9. | TPCC_GROUP | ORDL | TPCC |
    10. | TPCC_GROUP | ORDR | TPCC |
    11. | TPCC_GROUP | STOK | TPCC |
    12. | TPCC_GROUP | WARE | TPCC |
    13. | oceanbase | NULL | NULL |
    14. +-----------------+------------+---------------+
    15. 9 rows in set (0.02 sec)
    16. obclient> show create tablegroup tpcc_group\G
    17. *************************** 1. row ***************************
    18. TABLEGROUP: TPCC_GROUP
    19. CREATE TABLEGROUP: CREATE TABLEGROUP "TPCC_GROUP" BINDING = FALSE
    20. partition by hash partitions 6
    21. 1 row in set (0.00 sec)