Show TOC

Partition Schemes (SQL Server)Locate this document in the navigation structure

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 Start of the navigation path Model Next navigation step Partition Schemes End of the navigation path 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 Start of the navigation path New Next navigation step Partition Scheme End of the navigation path.

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