All Products
Search
Document Center

PolarDB:SHOW TABLEGROUP (AUTO mode)

Last Updated:Aug 14, 2024

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 TABLE_SCHEMA='test_db';