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

Secondary Index: PARTITIONIDSIDX on fields: TABLENAME, SCHEMA, PARTITIONNAME