Updated on 2025-07-22 GMT+08:00

ADM_PART_TABLES

ADM_PART_TABLES displays information about all partitioned tables in the database. By default, only users with the SYSADMIN permission can access this system view. Common users can access it only after being authorized. This view exists in both the PG_CATALOG and SYS schemas.

Table 1 ADM_PART_TABLES columns

Name

Type

Description

table_owner

character varying(64)

Owner name of a partitioned table.

table_name

character varying(64)

Name of the partitioned table.

partitioning_type

text

Partitioning policy of the partitioned table.
NOTE:

For details about the supported partitioning policies of the current partitioned table, see CREATE TABLE PARTITION.

partition_count

bigint

Number of partitions of the partitioned table.

partitioning_key_count

integer

Number of partition keys of the partitioned table.

def_tablespace_name

name

Tablespace name of the partitioned table.

schema

character varying(64)

Schema of the partitioned table.

subpartitioning_type

text

Partitioning policy of a level-2 partitioned table. If the partitioned table is a level-1 partitioned table, NONE is displayed.

NOTE:

For details about the supported partitioning policies of the current level-2 partitioned table, see CREATE TABLE SUBPARTITION.

def_subpartition_count

integer

Default number of level-2 partitions to be created. The value is 1 for a level-2 partitioned table and 0 for a level-1 partitioned table.

subpartitioning_key_count

integer

Number of level-2 partition keys of the partitioned table.