SYSPARTITION system view

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