# Partition Function: dataPF1

## Properties

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

## Extended Properties

Name | Value
--- | ---
MS_Description | mobi datePF1

## Parameters

Parameter ID | Datatype | Collation
--- | --- | ---
1 | datetime |

## Range Values

Boundary ID | Range Value
--- | ---
1 | 1/1/2007 12:00:00 AM
2 | 1/1/2010 12:00:00 AM

## Objects that depend on [dataPF1]

- dataPF1
  - datePS
    - Production.TransactionHistory
      - Production.WorkOrder
        - Production.iWorkOrder
        - Production.uWorkOrder
        - Production.WorkOrderRouting
      - Purchasing.PurchaseOrderDetail
        - Purchasing.iPurchaseOrderDetail
        - Purchasing.uPurchaseOrderDetail
      - Sales.SalesOrderDetail
        - Sales.iduSalesOrderDetail
        - Sales.ufn_SalesByStore

## Objects on which [dataPF1] depends

- dataPF1

## SQL

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'

#### See also

List of Partition Functions