Presents group information from ISYSPARTITIONSCHEME in a readable format.
Each row in the SYSPARTITIONSCHEME view describes a partitioned object (table or index) in the database.
ALTER VIEW "SYS"."SYSPARTITIONSCHEME" as select * from SYS.ISYSPARTITIONSCHEME
Column Name |
Column Type |
Description |
|---|---|---|
partitioned_object_id |
unsigned bigint |
Each partitioned object (table) is assigned a unique number. |
partition_method |
tinyint |
Partitioning method for this table. Valid values: 1 – for range and 3 – for hash (2 is unused). |
subpartition_method |
tinyint |
Subpartitioning method for this table. Valid values: NULL - no subpartitioning, 1 – for range partitioning, 3 – for hash partitioning (2 is unused). |
Constraints on underlying system table:
Primary key (partitioned_object_id)
Foreign key (partitioned_object_id) references SYS.ISYSOBJECT