Presents group information from ISYSPARTITION in a readable format.
Each row in the SYSPARTITION view describes a partitioned object (table or index) in the database. The underlying system table for this view is ISYSPARTITION.
Column name |
Column type |
Description |
|---|---|---|
partitioned_object_id |
unsigned bigint |
Unique number assigned to each partitioned object (table) |
partition_id |
unsigned int |
Identifies a partition in a partitioned table. |
partition_object_id |
unsigned bigint |
Each table partition is an object itself and is assigned a unique number from the table object or index object. |
partition_values |
long varchar |
Contains partitioning criteria for range or list partitioning. For range partitioning, values contain the upper bound for this partition. For list partitioning, values contain list of values separated by ‘,’. Position is the ordinal number of partition. |
position |
unsigned int |
Ordinal number of partition. For ranged partition, for position 2 and above, the partition at (position-1) contains its exclusive lower bound. |
partition_name |
char(128) |
Name of partition |
Constraints on underlying system table:
Primary key (partitioned_object_id, partition_id)
Unique (partition_object_id, position)
Foreign key (partition_object_id) references SYS.ISYSOBJECT
Foreign key (partitioned_object_id) references SYS.ISYSOBJECT