ALTER VIEW "SYS"."SYSPARTITIONKEY" as select * from SYS.ISYSPARTITIONKEY
Presents group information from ISYSPARTITIONKEY in a readable format. Each row in the SYSPARTITIONKEY view describes a partitioned object (table or index) in the database.
Column name |
Column type |
Description |
|---|---|---|
partitioned_object_id |
unsigned bigint |
Each partitioned object (table) is assigned a unique object number. |
column_id |
unsigned int |
The column ID identifies the table column as part of the partitioning key. |
position |
smallint |
Position of this column in the partitioning key. Position is 0 based. A position of 0 indicates the 1st 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
