ADM_SUBPART_KEY_COLUMNS

ADM_SUBPART_KEY_COLUMNS displays information about the partition key columns of level-2 partitioned tables or partitioned indexes in the database. By default, only the system administrator can access this view. Common users can access the view only after being authorized. This view exists in both PG_CATALOG and SYS schemas.

**Table 1** ADM_SUBPART_KEY_COLUMNS columns
Name	Type	Description
owner	character varying(128)	Owner of a level-2 partitioned table or index.
name	character varying(128)	Name of a level-2 partitioned table or index.
object_type	character(5)	Object type. Its value is table for a level-2 partitioned table. Its value is index for a level-2 partitioned index.
column_name	character varying(4000)	Partition key column name of a level-2 partitioned table or index.
column_position	numeric	Position of a column in a partition.
collated_column_id	numeric	Not supported. Its value is NULL.