Partition Scheme: myRangePS1 Partition Scheme: myRangePS1| Property | Value |
|---|---|
| Name | myRangePS1 |
| ID | 65601 |
| Partition Function | myRangePF1 |
| Partition Function Boundary Values | LEFT |
| Name | Value |
|---|---|
| MS_Description | ps1 - update |
| Destination ID | Value | Filegroup Name |
|---|---|---|
| 1 | 1 | test1fg |
| 2 | 100 | test2fg |
| 3 | 1000 | test3fg |
| 4 | test4fg |
| Script |
|---|
| CREATE PARTITION SCHEME [myRangePS1] AS PARTITION [myRangePF1] TO ([test1fg], [test2fg], [test3fg], [test4fg]) EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ps1 - update' , @level0type=N'PARTITION SCHEME',@level0name=N'myRangePS1' |