Updated on 2024-05-07 GMT+08:00

DB_SUBPART_KEY_COLUMNS

DB_SUBPART_KEY_COLUMNS displays information about the partition key columns of level-2 partitioned tables or partitioned indexes accessible to the current user. This view is accessible to all users and displays all information accessible to the current user. This view exists in both PG_CATALOG and SYS schema. The distributed system does not support level-2 partitioned tables. All columns in this view are set to NULL.

Table 1 DB_SUBPART_KEY_COLUMNS columns

Name

Type

Description

owner

character varying(128)

Not supported. Its value is NULL.

name

character varying(128)

Not supported. Its value is NULL.

object_type

character varying(128)

Not supported. Its value is NULL.

column_name

character varying(4000)

Not supported. Its value is NULL.

column_position

numeric

Not supported. Its value is NULL.

collated_column_id

numeric

Not supported. Its value is NULL.