PARTITIONIDS System Table Description

Description

This table lists the ID for the table partitions.

Fields

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.

Indexes

None