# Xml Schema: ManuInstructionsSchemaCollection

## Properties

Property | Value
--- | ---
Name | ManuInstructionsSchemaCollection
ID | 65540
Schema | Production
Owner | dbo
Modify Date | 8/8/2010 5:21:46 PM
Create Date | 8/8/2010 5:21:46 PM

## Extended Properties

Name | Value
--- | ---
MS_Description | Collection of XML schemas for the Instructions column in the Production.ProductModel table.

## [ManuInstructionsSchemaCollection] is used in the following columns

Schema | Object | Column
--- | --- | ---
Production | ProductModel | Instructions

## [ManuInstructionsSchemaCollection] is used in the following parameters

Xml Collection is not used in any parameters

## Xml Namespaces

ID | Name
--- | ---
1 | http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelManuInstructions

## Permissions

No object level permissions defined.

## Objects that depend on [ManuInstructionsSchemaCollection]

- Production.ManuInstructionsSchemaCollection
  - Production.ProductModel
    - Production.Product
      - Production.BillOfMaterials
        - dbo.uspGetBillOfMaterials
          - HumanResources.ProcedureSynonym
        - dbo.uspGetWhereUsedProductID
      - Production.ProductListPriceHistory
        - dbo.ufnGetProductDealerPrice
          - Person.functionSynonym
        - dbo.ufnGetProductListPrice
      - Sales.SpecialOfferProduct
        - Sales.SalesOrderDetail
          - Sales.iduSalesOrderDetail
          - Sales.ufn_SalesByStore
      - Production.TransactionHistory
        - Purchasing.PurchaseOrderDetail
          - Purchasing.iPurchaseOrderDetail
          - Purchasing.uPurchaseOrderDetail
        - Production.WorkOrder
          - Production.WorkOrderRouting
          - Production.uWorkOrder
          - Production.iWorkOrder
      - Production.ProductInventory
        - dbo.ufnGetStock
      - Production.ProductCostHistory
        - dbo.ufnGetProductStandardCost
      - Production.uspGetList
      - Production.vProductAndDescription
      - Production.ProductDocument
      - dbo.KrystianProductView
      - Production.ProductProductPhoto
      - Production.ProductReview
      - Purchasing.ProductVendor
      - Sales.ShoppingCartItem
    - Production.ProductModelProductDescriptionCulture
    - Production.vProductModelCatalogDescription
    - Production.vProductModelInstructions
    - Production.ProductModelIllustration

## Objects on which [ManuInstructionsSchemaCollection] depends

- Production.ManuInstructionsSchemaCollection

## SQL

Script
CREATE XML SCHEMA COLLECTION [Production].[ManuInstructionsSchemaCollection] AS N'<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:t="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelManuInstructions" targetNamespace="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelManuInstructions" elementFormDefault="qualified"><xsd:element name="root"><xsd:complexType mixed="true"><xsd:complexContent mixed="true"><xsd:restriction base="xsd:anyType"><xsd:sequence><xsd:element name="Location" maxOccurs="unbounded"><xsd:complexType mixed="true"><xsd:complexContent mixed="true"><xsd:restriction base="xsd:anyType"><xsd:sequence><xsd:element name="step" type="t:StepType" maxOccurs="unbounded" /></xsd:sequence><xsd:attribute name="LocationID" type="xsd:integer" use="required" /><xsd:attribute name="SetupHours" type="xsd:decimal" /><xsd:attribute name="MachineHours" type="xsd:decimal" /><xsd:attribute name="LaborHours" type="xsd:decimal" /><xsd:attribute name="LotSize" type="xsd:decimal" /></xsd:restriction></xsd:complexContent></xsd:complexType></xsd:element></xsd:sequence></xsd:restriction></xsd:complexContent></xsd:complexType></xsd:element><xsd:complexType name="StepType" mixed="true"><xsd:complexContent mixed="true"><xsd:restriction base="xsd:anyType"><xsd:choice minOccurs="0" maxOccurs="unbounded"><xsd:element name="tool" type="xsd:string" /><xsd:element name="material" type="xsd:string" /><xsd:element name="blueprint" type="xsd:string" /><xsd:element name="specs" type="xsd:string" /><xsd:element name="diag" type="xsd:string" /></xsd:choice></xsd:restriction></xsd:complexContent></xsd:complexType></xsd:schema>' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Collection of XML schemas for the Instructions column in the Production.ProductModel table.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'XML SCHEMA COLLECTION',@level1name=N'ManuInstructionsSchemaCollection'

#### See also

List of Xml Collections