DB_TAB_PARTITIONS

DB_TAB_PARTITIONS displays information about partitioned tables accessible to the current user. This view exists in the PG_CATALOG and SYS schemas.

**Table 1** DB_TAB_PARTITIONS columns
Name	Type	Description
table_owner	character varying(64)	Role name
table_name	character varying(64)	Relational table name
partition_name	character varying(64)	Partition name
high_value	text	Limit of a partition NOTE: For range partitioning and interval partitioning, the upper limit of each partition is displayed. For list partitioning, the value list of each partition is displayed. For hash partitioning, the number of each partition is displayed.
tablespace_name	name	Tablespace name of a partitioned table
schema	character varying(64)	Name of a namespace
subpartition_count	bigint	Number of level-2 partitions
high_value_length	integer	Character length of the limit of a partition