This topic describes how to view the information about a table group.
Syntax
You can use the SHOW TABLEGROUPS and SHOW CREATE TABLE commands to view the information about a table group.
Examples
Example 1
View the information about the tablegroups table group.
obclient> SHOW TABLEGROUP;
+-----------------+------------+---------------+
| Tablegroup_name | Table_name | Database_name |
+-----------------+------------+---------------+
| oceanbase | NULL | NULL |
| tpcc_group | ordr | test |
+-----------------+------------+---------------+
2 rows in set
Example 2
View the definition of the tablegroups table group.
obclient> SHOW CREATE TABLEGROUP tpcc_group\G
*************************** 1. row ***************************
Tablegroup: tpcc_group
Create Tablegroup: CREATE TABLEGROUP IF NOT EXISTS `tpcc_group` BINDING = FALSE
partition by hash partitions 6
1 row in set