You can execute the SHOW TABLEGROUP statement to view information about the table groups of a database instance, including the partitions in each table group and tables in each table group.

Syntax

show_tablegroup_stmt:
    SHOW tablegroup [WHERE where_condition]

Examples

Query all tablegroup information in the test_db database. 

SHOW TABLEGROUP WHERE schema_name='test_db';