partition scheme icon Partition Scheme: myRangePS5

Properties

Property Value
Name myRangePS5
ID 65610
Partition Function myRangePF5
Partition Function Boundary Values LEFT

Extended Properties

No extended properties defined.

Partition Schame File Groups Mappings

Destination ID Value Filegroup Name
1 1 test1fg
2 100 test2fg
3 1000 test3fg
4 test4fg
5 test4fg

Objects that depend on [myRangePS5]

Objects on which [myRangePS5] depends

SQL

Script
CREATE PARTITION SCHEME [myRangePS5] AS PARTITION [myRangePF5] TO ([test1fg], [test2fg], [test3fg], [test4fg])

See also

List of Partition Schemes