Partition Schemes

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 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

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