Help Center/ GaussDB/ Developer Guide(Centralized_8.x)/ System Catalogs and System Views/ System Views/ Partitioned Table/ MY_SUBPART_KEY_COLUMNS
Updated on 2024-08-20 GMT+08:00
View PDF
Share

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 both PG_CATALOG and SYS schemas.

Table 1 MY_SUBPART_KEY_COLUMNS columns

Name

Type

Description

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 partitioned table.
  • Its value is index for a 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.
Parent topic: Partitioned Table