MY_PART_KEY_COLUMNS

MY_PART_KEY_COLUMNS displays information about the partition key columns of partitioned tables or partitioned indexes owned by the current user. This view can be accessed by all users. Only the information about the current user can be viewed. This view exists in both PG_CATALOG and SYS schema.

**Table 1** MY_PART_KEY_COLUMNS columns
Name	Type	Description
name	character varying(128)	Name of a partitioned table or index.
object_type	character varying(128)	Valid values are table and index. If the partition is a partitioned table, the value is table. If the partition is a partitioned index, the value is index.
column_name	character varying(4000)	Partition key column name of a partitioned table or index.
column_position	numeric	Position of a column in a partition.
collated_column_id	numeric	Not supported. Its value is NULL.