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