This topic describes how to view the information about a partitioned table group.
Syntax
You can use the SHOW TABLEGROUPS and SHOW CREATE TABLEGROUP commands to view the information about a table group.
Examples
View a table group
obclient> SHOW TABLEGROUPS;
+-----------------+------------+---------------+
| TABLEGROUP_NAME | TABLE_NAME | DATABASE_NAME |
+-----------------+------------+---------------+
| TPCC_GROUP | ORDL | SYS |
| TPCC_GROUP | ORDR | SYS |
| oceanbase | NULL | NULL |
+-----------------+------------+---------------+
3 rows in set
View information about a table group
View the information about the tpcc_group table group.
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