# Xml Schema: ProductDescriptionSchemaCollection

## Properties

Property | Value
--- | ---
Name | ProductDescriptionSchemaCollection
ID | 65539
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 CatalogDescription column in the Production.ProductModel table.

## [ProductDescriptionSchemaCollection] is used in the following columns

Schema | Object | Column
--- | --- | ---
Production | ProductModel | CatalogDescription

## [ProductDescriptionSchemaCollection] 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/ProductModelWarrAndMain
2 | http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription

## Permissions

No object level permissions defined.

## Objects that depend on [ProductDescriptionSchemaCollection]

- Production.ProductDescriptionSchemaCollection
  - 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 [ProductDescriptionSchemaCollection] depends

- Production.ProductDescriptionSchemaCollection

## SQL

Script
CREATE XML SCHEMA COLLECTION [Production].[ProductDescriptionSchemaCollection] AS N'<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:t="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelWarrAndMain" targetNamespace="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelWarrAndMain" elementFormDefault="qualified"><xsd:element name="Maintenance"><xsd:complexType><xsd:complexContent><xsd:restriction base="xsd:anyType"><xsd:sequence><xsd:element name="NoOfYears" type="xsd:string" /><xsd:element name="Description" type="xsd:string" /></xsd:sequence></xsd:restriction></xsd:complexContent></xsd:complexType></xsd:element><xsd:element name="Warranty"><xsd:complexType><xsd:complexContent><xsd:restriction base="xsd:anyType"><xsd:sequence><xsd:element name="WarrantyPeriod" type="xsd:string" /><xsd:element name="Description" type="xsd:string" /></xsd:sequence></xsd:restriction></xsd:complexContent></xsd:complexType></xsd:element></xsd:schema><xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:ns1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelWarrAndMain" xmlns:t="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription" targetNamespace="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription" elementFormDefault="qualified"><xsd:import namespace="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelWarrAndMain" /><xsd:element name="Code" type="xsd:string" /><xsd:element name="Description" type="xsd:string" /><xsd:element name="ProductDescription" type="t:ProductDescription" /><xsd:element name="Taxonomy" type="xsd:string" /><xsd:complexType name="Category"><xsd:complexContent><xsd:restriction base="xsd:anyType"><xsd:sequence><xsd:element ref="t:Taxonomy" /><xsd:element ref="t:Code" /><xsd:element ref="t:Description" minOccurs="0" /></xsd:sequence></xsd:restriction></xsd:complexContent></xsd:complexType><xsd:complexType name="Features" mixed="true"><xsd:complexContent mixed="true"><xsd:restriction base="xsd:anyType"><xsd:sequence><xsd:element ref="ns1:Warranty" /><xsd:element ref="ns1:Maintenance" /><xsd:any namespace="##other" processContents="skip" minOccurs="0" maxOccurs="unbounded" /></xsd:sequence></xsd:restriction></xsd:complexContent></xsd:complexType><xsd:complexType name="Manufacturer"><xsd:complexContent><xsd:restriction base="xsd:anyType"><xsd:sequence><xsd:element name="Name" type="xsd:string" minOccurs="0" /><xsd:element name="CopyrightURL" type="xsd:string" minOccurs="0" /><xsd:element name="Copyright" type="xsd:string" minOccurs="0" /><xsd:element name="ProductURL" type="xsd:string" minOccurs="0" /></xsd:sequence></xsd:restriction></xsd:complexContent></xsd:complexType><xsd:complexType name="Picture"><xsd:complexContent><xsd:restriction base="xsd:anyType"><xsd:sequence><xsd:element name="Name" type="xsd:string" minOccurs="0" /><xsd:element name="Angle" type="xsd:string" minOccurs="0" /><xsd:element name="Size" type="xsd:string" minOccurs="0" /><xsd:element name="ProductPhotoID" type="xsd:integer" minOccurs="0" /></xsd:sequence></xsd:restriction></xsd:complexContent></xsd:complexType><xsd:complexType name="ProductDescription"><xsd:complexContent><xsd:restriction base="xsd:anyType"><xsd:sequence><xsd:element name="Summary" type="t:Summary" minOccurs="0" /><xsd:element name="Manufacturer" type="t:Manufacturer" minOccurs="0" /><xsd:element name="Features" type="t:Features" minOccurs="0" maxOccurs="unbounded" /><xsd:element name="Picture" type="t:Picture" minOccurs="0" maxOccurs="unbounded" /><xsd:element name="Category" type="t:Category" minOccurs="0" maxOccurs="unbounded" /><xsd:element name="Specifications" type="t:Specifications" minOccurs="0" maxOccurs="unbounded" /></xsd:sequence><xsd:attribute name="ProductModelID" type="xsd:string" /><xsd:attribute name="ProductModelName" type="xsd:string" /></xsd:restriction></xsd:complexContent></xsd:complexType><xsd:complexType name="Specifications" mixed="true"><xsd:complexContent mixed="true"><xsd:restriction base="xsd:anyType"><xsd:sequence><xsd:any processContents="skip" minOccurs="0" maxOccurs="unbounded" /></xsd:sequence></xsd:restriction></xsd:complexContent></xsd:complexType><xsd:complexType name="Summary" mixed="true"><xsd:complexContent mixed="true"><xsd:restriction base="xsd:anyType"><xsd:sequence><xsd:any namespace="http://www.w3.org/1999/xhtml" processContents="skip" minOccurs="0" maxOccurs="unbounded" /></xsd:sequence></xsd:restriction></xsd:complexContent></xsd:complexType></xsd:schema>' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Collection of XML schemas for the CatalogDescription column in the Production.ProductModel table.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'XML SCHEMA COLLECTION',@level1name=N'ProductDescriptionSchemaCollection'

#### See also

List of Xml Collections