Partition Scheme: myRangePS2 Partition Scheme: myRangePS2| Property | Value |
|---|---|
| Name | myRangePS2 |
| ID | 65602 |
| Partition Function | myRangePF2 |
| Partition Function Boundary Values | RIGHT |
| Destination ID | Value | Filegroup Name |
|---|---|---|
| 1 | 1 | test1fg |
| 2 | 100 | test1fg |
| 3 | 1000 | test1fg |
| 4 | test2fg |
| Script |
|---|
| CREATE PARTITION SCHEME [myRangePS2] AS PARTITION [myRangePF2] TO ([test1fg], [test1fg], [test1fg], [test2fg]) |