# Partition Scheme: datePS

## Properties

Property | Value
--- | ---
Name | datePS
ID | 65607
Partition Function | dataPF1
Partition Function Boundary Values | LEFT

## Extended Properties

Name | Value
--- | ---
MS_Description | mobi partition scheme

## Partition Schame File Groups Mappings

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

## Objects that depend on [datePS]

- 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 [datePS] depends

- datePS
  - dataPF1

## SQL

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'

#### See also

List of Partition Schemes