Partition Scheme: datePS Partition Scheme: datePS| Property | Value |
|---|---|
| Name | datePS |
| ID | 65607 |
| Partition Function | dataPF1 |
| Partition Function Boundary Values | LEFT |
| Name | Value |
|---|---|
| MS_Description | mobi partition scheme |
| Destination ID | Value | Filegroup Name |
|---|---|---|
| 1 | 1/1/2007 12:00:00 AM | test1fg |
| 2 | 1/1/2010 12:00:00 AM | test2fg |
| 3 | test3fg |
| Script |
|---|
| CREATE PARTITION SCHEME [datePS] AS PARTITION [dataPF1] TO ([test1fg], [test2fg], [test3fg]) EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'mobi partition scheme' , @level0type=N'PARTITION SCHEME',@level0name=N'datePS' |