You are here: Reference Information > SQL Reference Information > SQL System Tables > PARTITIONIDS System Table Description

PARTITIONIDS System Table Description


This table lists the ID for the table partitions.


Field Type Description
SCHEMA string The schema in which the partitioned table exists.
TABLENAME string The name of the partitioned table.
PARTITIONNAME string The name of the partition in the table.
PARTITIONID bigint The ID for this table partition.
STORAGEGROUP string The storage group which will be used by this table partition.