Presents group information from the ISYSSUBPARTITIONKEY system table in a readable format.
The SYSSUBPARTITIONKEY system view contains one row for each column of a partition described in ISYSPARTITION view in a partitioned table described in the ISYSPARTITIONSCHEME view.
Column Name | Datatype | Description |
---|---|---|
partitioned_object_id |
unsigned bigint |
Unique number assigned to each partitioned object (table or index). |
column_id |
unsigned int |
Identifies which column of the table as part of the partitioning key, Together, partitioned_object_id and column_id identify one column described in the SYSTABCOL system view. |
position |
smallint |
Position of the column in the partitioning key. A value of 0 indicates the 1st column in the partitioning key. A value of 1 indicates the 2nd column in the partitioning key. |
Constraints on underlying system table:
Primary key (partitioned_object_id, column_id)
Foreign Key (partitioned_object_id) references SYS.ISYSOBJECT