ALTER VIEW "SYS"."SYSPARTITION" as select * from SYS.ISYSPARTITION
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.
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 the upper bound for this range partition. |
position |
unsigned int |
Ordinal number of partition. |
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
