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

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.

Indexes

None