ALTER VIEW "SYS"."SYSPARTITIONSCHEME" as select * from SYS.ISYSPARTITIONSCHEME
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.
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
