partition function icon Partition Function: myRangePF3

Properties

Property Value
Name myRangePF3
ID 65539
Type RANGE
Number of partitions 4
Boundary RIGHT
Modify Date 10/26/2011 11:23:17 PM
Create Date 10/26/2011 11:23:17 PM

Extended Properties

No extended properties defined.

Parameters

Parameter ID Datatype Collation
1 char(20) SQL_Latin1_General_CP1_CI_AS
1 SpecialCode SQL_Latin1_General_CP1_CI_AS

Range Values

Boundary ID Range Value
1 EX
2 RXE
3 XR

Objects that depend on [myRangePF3]

Objects on which [myRangePF3] depends

SQL

Script
CREATE PARTITION FUNCTION [myRangePF3](char(20)) AS RANGE RIGHT FOR VALUES (N'EX ', N'RXE ', N'XR ')

See also

List of Partition Functions