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 |
The partitioning method for this table. Valid values: 1– for range Sybase IQ supports only range partitioning. |
subpartition_method |
tinyint |
Reserved for future use. |
Constraints on underlying system table:
Primary key (partitioned_object_id)
Foreign key (partitioned_object_id) references SYS.ISYSOBJECT