ADM_TAB_SUBPARTITIONS

ADM_TAB_SUBPARTITIONS displays information about all level-2 partitions 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_TAB_SUBPARTITIONS 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.
subpartition_name	character varying(64)	Name of a level-2 partition.
high_value	text	Limit of a level-2 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 level-2 partitioned table.
schema	character varying(64)	Name of a namespace.
high_value_length	integer	Character length of the limit of a level-2 partition.