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
