Partition Function: dataPF1 Partition Function: dataPF1| Property | Value |
|---|---|
| Name | dataPF1 |
| ID | 65542 |
| Type | RANGE |
| Number of partitions | 3 |
| Boundary | LEFT |
| Modify Date | 10/26/2011 11:48:55 PM |
| Create Date | 10/26/2011 11:48:55 PM |
| Name | Value |
|---|---|
| MS_Description | mobi datePF1 |
| Parameter ID | Datatype | Collation |
|---|---|---|
| 1 | datetime |
| Boundary ID | Range Value |
|---|---|
| 1 | 1/1/2007 12:00:00 AM |
| 2 | 1/1/2010 12:00:00 AM |
| Script |
|---|
| CREATE PARTITION FUNCTION [dataPF1](datetime) AS RANGE LEFT FOR VALUES (N'2007-01-01T00:00:00.000', N'2010-01-01T00:00:00.000') EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'mobi datePF1' , @level0type=N'PARTITION FUNCTION',@level0name=N'dataPF1' |