SYSIQPARTITIONCOLUMN system view

ALTER VIEW "SYS"."SYSIQPARTITIONCOLUMN"
as select * from SYS.ISYSIQPARTITIONCOLUMN

Presents group information from ISYSIQPARTITIONCOLUMN in a readable format. Each row in the SYSIQPARTITIONCOLUMN view describes a column in a partition described in the SYSIQPARTITION view in a partitioned table described in the SYSPARTITIONSCHEME view. SYSIQPARTITIONCOLUMN only describes partitions of columns that are not stored on the dbspace of the partition.

Column name

Column type

Description

partitioned_object_id

unsigned bigint

Unique ID assigned to each partitioned object (table)

partition_id

unsigned int

Identifies a partition in a partitioned table.

column_id

unsigned int

The column ID of the column.

dbspace_id

smallint

The dbspace ID of the dbspace where this column of the partition is stored.

Constraints on underlying system table

Primary key (partitioned_object_id, partition_id, column_id)

Foreign key (partitioned_object_id, partition_id) references SYS.ISYSPARTITION

Foreign key (dbspace_id) references SYS.ISYSDBSPACE