Online Documentation for SQL Manager for SQL server

Partition Functions

A Partition function specifies how a table or Index is partitioned. The function maps the domain into a set of partitions. When creating a partition function, you specify the number of partitions, the partitioning column, and the range of partition column values for each partition. Note that when you specify the partitioning column, you can only specify one.


Partition Function Editor allows you to define partition function properties. It opens automatically when you create a new partition function and is available on editing an existing one.


To open a partition function in Partition Function Editor, double-click it in the DB Explorer tree.