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

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

    1. obclient> show tablegroups;
    2. +-----------------+------------+---------------+
    3. | Tablegroup_name | Table_name | Database_name |
    4. +-----------------+------------+---------------+
    5. | oceanbase | NULL | NULL |
    6. | tpcc_group | cust | tpccdb |
    7. | tpcc_group | dist | tpccdb |
    8. | tpcc_group | hist | tpccdb |
    9. | tpcc_group | nord | tpccdb |
    10. | tpcc_group | ordl | tpccdb |
    11. | tpcc_group | ordr | tpccdb |
    12. | tpcc_group | stok | tpccdb |
    13. | tpcc_group | ware | tpccdb |
    14. +-----------------+------------+---------------+
    15. 9 rows in set (0.01 sec)
    16. obclient> show create tablegroup tpcc_group\G
    17. *************************** 1. row ***************************
    18. Tablegroup: tpcc_group
    19. Create Tablegroup: CREATE TABLEGROUP IF NOT EXISTS `tpcc_group` BINDING = FALSE
    20. partition by hash partitions 6
    21. 1 row in set (0.00 sec)