Help Center/ GaussDB/ Feature Guide(Distributed_8.x)/ Partitioned Table/ System Views & DFX Related to Partitioned Tables/ System Views Related to Partitioned Tables
Updated on 2024-06-07 GMT+08:00
View PDF
Share

System Views Related to Partitioned Tables

The system views related to partitioned tables are classified into three types based on permissions. For details about the columns, see section "System Catalogs and System Views > System Views" in Developer Guide.
  1. Views related to all partitions:
    • ADM_PART_TABLES: stores information about all partitioned tables.
    • ADM_TAB_PARTITIONS: stores information about all partitions.
    • ADM_PART_INDEXES: stores information about all local indexes.
    • ADM_IND_PARTITIONS: stores information about all index partitions.
  2. Views accessible to the current user:
    • DB_PART_TABLES: stores information about partitioned tables accessible to the current user.
    • DB_TAB_PARTITIONS: stores information about partitions accessible to the current user.
    • DB_PART_INDEXES: stores local index information accessible to the current user.
    • DB_IND_PARTITIONS: stores information about index partitions accessible to the current user.
  3. Views owned by the current user:
    • MY_PART_TABLES: stores information about partitioned tables owned by the current user.
    • MY_TAB_PARTITIONS: stores information about partitions owned by the current user.
    • MY_PART_INDEXES: stores local indexes owned by the current user.
    • MY_IND_PARTITIONS: stores information about index partitions owned by the current user.