Updated on 2024-06-03 GMT+08:00

MY_SUBPART_KEY_COLUMNS

MY_SUBPART_KEY_COLUMNS displays information about the partition key columns of level-2 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 the PG_CATALOG and SYS schemas. The distributed system does not support level-2 partitioned tables. All columns in this view are set to NULL.

Table 1 MY_SUBPART_KEY_COLUMNS columns

Name

Type

Description

name

character varying(128)

Not supported. The value is NULL.

object_type

character varying(128)

Not supported. The value is NULL.

column_name

character varying(4000)

Not supported. The value is NULL.

column_position

numeric

Not supported. The value is NULL.

collated_column_id

numeric

Not supported. The value is NULL.