Table Partition Rules

A table partition name is associated with a partitioning criterion. Data that satisfies the criterion is stored in the storage group associated with the table partition name.

The following rules govern table partitions:

  • A table partition is local to the table, that is, it has rows from one table only.

  • A table partition is associated with exactly one storage group.

  • A version of a row in a partitioned table is mapped to exactly one table partition.

  • A table can only have one partition policy defined.

  • In addition to associating a table with multiple storage groups, a table can be created and assigned to just one storage group.

  • SQL DDL commands CREATE TABLE and ALTER TABLE are used to manage table partitions and associate them with storage groups.

  • Supported partitioning types are range partitioning (BY RANGE) and list partitioning (BY LIST).

  • The limit on the number of partitions in a table is 231.