SYSPARTITIONSCHEME System View

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