Share via

Figure 1: Product schema to define an XML View

  • Article
<?xml version="1.0" encoding="utf-8" ?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
              xmlns:sql="urn:schemas-microsoft-com:mapping-schema">
    <xs:complexType name="ProductType">
      <xs:sequence>
        <xs:element name="ProductID" type="xs:int" />
        <xs:element name="ProductName" type="xs:string" />
        <xs:element name="UnitsInStock" type="xs:int" />
      </xs:sequence>
    </xs:complexType>
    <xs:element name="Products" sql:is-constant="1">
      <xs:complexType>
        <xs:sequence>
           <xs:element name="Product" type="ProductType"
               sql:relation="Products" />
        </xs:sequence>
      </xs:complexType>
    </xs:element>
</xs:schema>