Partition Functions (SQL Server)

A partition function specifies how a table or index can be partitioned. PowerDesigner models partition functions as extended objects with a stereotype of <<PartitionFunction>>.

Creating a Partition Function

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

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

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

Partition Function Properties

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

The following extended attributes are available on the Microsoft tab:

Name

Description

Input Parameter Type

Specifies the data type of the column used for partitioning. All data types are valid, except text, ntext, image, xml, timestamp, varchar(max), nvarchar(max), varbinary(max), alias data types, or CLR user-defined data types.

Scripting name: InputParameterType

Length

Specifies the length of input parameter data type.

Scripting name: InputParameterLength

Precision

Specifies the precision of input parameter data type

Scripting name: InputParameterPrec

Interval Side

Specifies to which side of each boundary value interval the boundary_value [,...n ] belongs. You can choose between:

  • left [default]

  • right

Interval values are sorted by the Database Engine in ascending order from left to right.

Scripting name: IntervalSide

Boundary Values

Specifies the boundary values for each partition of a partitioned table or index. All values must be separated by commas.

Scripting name: BoundaryValues