PARTITIONEDTABLES System Table Description


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


Field Type Description
SCHEMA string The schema in which the partitioned table exists.
TABLENAME string The name of the partitioned table.

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.