Help Center/ GaussDB/ Centralized_3.x/ Partitioned Table/ System Views & DFX Related to Partitioned Tables/ System Views Related to Partitioned Tables
Updated on 2024-05-20 GMT+08:00
View PDF

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_TAB_SUBPARTITIONS: stores information about all level-2 partitions.
    • ADM_PART_INDEXES: stores information about all local indexes.
    • ADM_IND_PARTITIONS: stores index partition information about all partitioned tables.
    • ADM_IND_SUBPARTITIONS: stores index partition information about all level-2 partitioned tables.
  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_TAB_SUBPARTITIONS: stores information about level-2 partitions accessible to the current user.
    • DB_PART_INDEXES: stores local index information accessible to the current user.
    • DB_IND_PARTITIONS: stores index partition information about partitioned tables accessible to the current user.
    • DB_IND_SUBPARTITIONS: stores index partition information about level-2 partitioned tables 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_TAB_SUBPARTITIONS: stores information about level-2 partitions owned by the current user.
    • MY_PART_INDEXES: stores local indexes owned by the current user.
    • MY_IND_PARTITIONS: stores index partition information about partitioned tables owned by the current user.
    • MY_IND_SUBPARTITIONS: stores index partition information about level-2 partitioned tables owned by the current user.