text: ﻿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>';
  
  
  GO
  EXECUTE 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';
  
  