PARTITIONEDTABLES System Table Description

Description

This table contains an entry for every partitioned table in your database.

Fields

Field Type Description

SCHEMA

string

The schema in which the partitioned table exists.

TABLENAME

string

The name of the partitioned table.

PARTITIONTYPE

integer

What type of partition is used for this table:

  • 1 = partition by list

  • 3 = partition by range

  • 5 = table partition (as in CREATE TABLE …​ store in storagegroup;)

PARTITIONINGCOLUMN

string

The name of the partitioning column, that is the column for which you supplied a PARTITION BY clause.

DEFAULTPARTITION

string

The name of the default partition, if one exists for this partitioned table.

DEFAULTSTORAGEGROUP

string

The name of the default storage group. For more information on using the storage_group parameter with a STORE IN clause, see CREATE TABLE.

Indexes

Secondary Index: IDX_PARTITIONED_TABLES on fields: SCHEMA, TABLENAME