Partition Schemes (SQL Server)

A partition scheme maps the partitions produced by a partition function to a set of user-defined filegroups. PowerDesigner models partition schemes as extended objects with a stereotype of <<PartitionScheme>>.

Creating a Partition Scheme

You can create a partition scheme in any of the following ways:

  • Select Model > Partition Schemes to access the List of Partition Schemes, and click the Add a Row tool.

  • Right-click the model (or a package) in the Browser, and select New > Partition Scheme.

Partition Scheme Properties

You can modify an object's properties from its property sheet. To open a partition scheme property sheet, double-click its diagram symbol or its Browser entry in the Partition Schemes folder.

The following extended attributes are available on the Microsoft tab:

Name

Description

Partition Function

Specifies the partition function using the scheme. Partitions created by the partition function are mapped to the filegroups specified in the partition scheme.

Scripting name: PartitionFunction

All Partitions

Specifies that all partitions map to the filegroup specified by the File Groups property.

Scripting name: AllPartitions

File Groups

Specifies the names of the filegroups to hold the partitions specified by the partition function. If [PRIMARY] is specified, the partition is stored on the primary filegroup. If ALL is specified, only one filegroup name can be specified.

Scripting name: Filegroups
Parent topic: Horizontal Partitioning (SQL Server)