This topic has not yet been rated - Rate this topic

5.4 Relational Engine XML Schema for Version 2010/11

<?xml version="1.0" encoding="utf-8"?>
<xs:schema xmlns:RE="http://schemas.microsoft.com/sqlserver/RelationalEngine/Serialization/2010/11" xmlns:MM="http://schemas.microsoft.com/sqlserver/ManagementModel/Serialization/2010/11" attributeFormDefault="unqualified" elementFormDefault="qualified" targetNamespace="http://schemas.microsoft.com/sqlserver/RelationalEngine/Serialization/2010/11" xmlns:xs="http://www.w3.org/2001/XMLSchema">
  <xs:annotation>
    <xs:documentation>
  THE SCHEMA IS PROVIDED TO YOU ON AN "AS IS" BASIS, AND MICROSOFT
  DISCLAIMS ALL WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, INCLUDING,
  WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS
  FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT, AS TO THE SCHEMA OR ANY
  PRODUCT OR OTHER ITEM THAT MAY BE DEVELOPED USING THE SCHEMA.
 
  Without limiting the generality of the foregoing, Microsoft makes no
  warranty that any product or other item that may be developed using the
  schema, or any portion of the schema, will not infringe any copyright,
  patent, trade secret or other intellectual property right of any
  individual or legal entity in any country. It is your responsibility to
  obtain licenses to use any such intellectual property rights as appropriate.
 
  MICROSOFT IS NOT LIABLE FOR ANY DAMAGES OF ANY KIND ARISING OUT OF OR IN
  CONNECTION WITH THE USE OF THE SCHEMA, INCLUDING, WITHOUT LIMITATION, ANY
  DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL (INCLUDING LOST REVENUES OR LOST
  PROFITS), PUNITIVE OR SPECIAL DAMAGES, WHETHER OR NOT MICROSOFT HAS BEEN
  ADVISED OF SUCH DAMAGES.
 
  (c) Microsoft Corporation.  All rights reserved.
</xs:documentation>
  </xs:annotation>
  <xs:import namespace="http://schemas.microsoft.com/sqlserver/ManagementModel/Serialization/2010/11" />
  <!--Relational model simple types: alphabetical order-->
  <xs:simpleType name="BooleanType">
    <xs:restriction base="xs:string">
      <xs:enumeration value="True" />
      <xs:enumeration value="False" />
    </xs:restriction>
  </xs:simpleType>
  <xs:simpleType name="CompatibilityLevelEnumeration">
    <xs:restriction base="xs:string">
      <xs:enumeration value="Version80" />
      <xs:enumeration value="Version90" />
      <xs:enumeration value="Version100" />
      <xs:enumeration value="Current" />
    </xs:restriction>
  </xs:simpleType>
  <xs:simpleType name="DMLActionEnumeration">
    <xs:restriction base="xs:string">
      <xs:enumeration value="NoAction" />
      <xs:enumeration value="Cascade" />
      <xs:enumeration value="SetNull" />
      <xs:enumeration value="SetDefault" />
    </xs:restriction>
  </xs:simpleType>
  <xs:simpleType name="ExecuteAsEnumeration">
    <xs:restriction base="xs:string">
      <xs:enumeration value="Caller" />
      <xs:enumeration value="Self" />
      <xs:enumeration value="Owner" />
      <xs:enumeration value="ExecuteAsUser" />
    </xs:restriction>
  </xs:simpleType>
  <xs:simpleType name="LoginTypeEnumeration">
    <xs:restriction base="xs:string">
      <xs:enumeration value="Sql" />
      <xs:enumeration value="Windows" />
    </xs:restriction>
  </xs:simpleType>
  <xs:simpleType name="SortOrderEnumeration">
    <xs:restriction base="xs:string">
      <xs:enumeration value="Ascending" />
      <xs:enumeration value="Descending" />
    </xs:restriction>
  </xs:simpleType>
  <xs:simpleType name="UserTypeEnumeration">
    <xs:restriction base="xs:string">
      <xs:enumeration value="NoLogin" />
      <xs:enumeration value="SqlLogin" />
    </xs:restriction>
  </xs:simpleType>
  <xs:simpleType name="FillFactorType">
    <xs:restriction base="xs:short">
      <xs:minInclusive value="0"/>
      <xs:maxInclusive value="100"/>
    </xs:restriction>
  </xs:simpleType>
  <xs:simpleType name="MaxDopType">
    <xs:restriction base="xs:short">
      <xs:minInclusive value="-1"/>
      <xs:maxInclusive value="64"/>
    </xs:restriction>
  </xs:simpleType>
  <!-- Relational model complex types: alphabetical order-->
  <xs:complexType name="BaseSystemDataType">
    <xs:all>
      <xs:element name="SystemDataType" type="RE:SqlDataType" />
    </xs:all>
  </xs:complexType>
  <xs:complexType name="CollationType">
    <xs:all>
      <xs:element name="Name" type="RE:CollationEnumeration" />
    </xs:all>
  </xs:complexType>
  <xs:complexType name="ComputedColumnType">
    <xs:all>
      <xs:element name="Text" type="xs:string" />
      <xs:element name="IsPersisted" type="RE:BooleanType" />
    </xs:all>
  </xs:complexType>
  <xs:complexType name="DataType">
    <xs:sequence minOccurs="0" maxOccurs="1">
      <xs:choice minOccurs="1" maxOccurs="1">
        <xs:element name="SystemDataType" type="RE:SqlDataType" />
        <xs:element name="XmlDataType" type="RE:SqlDataType" />
        <xs:element name="ScalarDataType" type="RE:ScalarDataType" />
      </xs:choice>
    </xs:sequence>
    <xs:attribute ref="MM:ReferenceKey" use="optional" />
  </xs:complexType>
  <xs:complexType name="ExecutionContextType">
    <xs:all>
      <xs:element name="ContextType" type="RE:ExecuteAsEnumeration" />
      <xs:element minOccurs="0" name="User" type="MM:ReferenceType" />
    </xs:all>
  </xs:complexType>
  <xs:complexType name="IdentityType">
    <xs:sequence>
      <xs:element name="Seed" type="xs:unsignedInt" />
      <xs:element name="Increment" type="xs:unsignedInt" />
      <xs:element name=”NotForReplication” type=”xs:Boolean” />
    </xs:sequence>
  </xs:complexType>
  <xs:complexType name="ScalarDataType">
    <xs:all>
      <xs:element name="Name" type="xs:string"/>
    </xs:all>
  </xs:complexType>
<xs:complexType name="SqlDataType">
    <xs:all>
      <xs:element name="Length" type="xs:unsignedByte" />
      <xs:element name="NumericPrecision" type="xs:unsignedByte" />
      <xs:element name="NumericScale" type="xs:unsignedByte" />
      <xs:element name="TypeSpec" type="xs:string" />
    </xs:all>
  </xs:complexType>
  <!--Relational model elements: alphabetical order-->
  <xs:element name="CheckConstraint">
    <xs:complexType>
      <xs:complexContent>
        <xs:extension base="MM:InstanceType">
          <xs:all>
            <xs:element name="Parent" type="MM:ReferenceType" />
            <xs:element name="Name" type="xs:string" />
            <xs:element name="Text" type="xs:string" />
            <xs:element name="IsChecked" type="RE:BooleanType" />
            <xs:element name="IsEnabled" type="RE:BooleanType" />
            <xs:element name=”NotForReplication” type=”RE:BooleanType” />  
          </xs:all>
        </xs:extension>
      </xs:complexContent>
    </xs:complexType>
  </xs:element>
  <xs:element name="Column">
    <xs:complexType>
      <xs:complexContent>
        <xs:extension base="MM:InstanceType">
          <xs:all>
            <xs:element name="Name" type="xs:string" />
            <xs:element name="DataType" type="RE:DataType" />
            <xs:element name="Nullable" type="RE:BooleanType" />
            <xs:element name="IsColumnSet" type="RE:BooleanType" />
            <xs:element name="IsSparse" type="RE:BooleanType" />
            <xs:element name="RowGuidCol" type="RE:BooleanType" />
            <xs:element name="Collation" type="RE:CollationType" minOccurs="0" />
            <xs:element name="ComputedColumnInfo" type="RE:ComputedColumnType" minOccurs="0" />
            <xs:element name="IdentityColumnInfo" type="RE:IdentityType" minOccurs="0"/>
            <xs:element name="DefaultValue" type="MM:ReferenceType" minOccurs="0"/>
          </xs:all>
        </xs:extension>
      </xs:complexContent>
    </xs:complexType>
  </xs:element>
  <xs:element name="Database">
    <xs:complexType>
      <xs:complexContent>
        <xs:extension base="MM:InstanceType">
          <xs:all>
            <xs:element name="Name" type="xs:string" />
            <xs:element name="Collation" type="RE:CollationType" />
            <xs:element name="CompatibilityLevel" type="RE:CompatibilityLevelEnumeration" />
          </xs:all>
        </xs:extension>
      </xs:complexContent>
    </xs:complexType>
  </xs:element>
  <xs:element name="DatabaseRole">
    <xs:complexType>
      <xs:complexContent>
        <xs:extension base="MM:InstanceType">
          <xs:all>
            <xs:element name="Parent" type="MM:ReferenceType" />
            <xs:element name="Name" type="xs:string" />
            <xs:element name="Owner" type="MM:ReferenceType" minOccurs="0" />
          </xs:all>
        </xs:extension>
      </xs:complexContent>
    </xs:complexType>
  </xs:element>
  <xs:element name="DefaultConstraint">
    <xs:complexType>
      <xs:complexContent>
        <xs:extension base="MM:InstanceType">
          <xs:all>
            <xs:element name="Name" type="xs:string" />
            <xs:element name="Text" type="xs:string" />
          </xs:all>
        </xs:extension>
      </xs:complexContent>
    </xs:complexType>
  </xs:element>
  <xs:element name="DmlTrigger">
    <xs:complexType>
      <xs:complexContent>
        <xs:extension base="MM:InstanceType">
          <xs:all>
            <xs:element name="Parent" type="MM:ReferenceType" />
            <!-- reference to On {table | view} -->
            <xs:element name="Name" type="xs:string" />
            <xs:element name="BodyText" type="xs:string" />
            <xs:element name="InsteadOf" type="RE:BooleanType" />
            <xs:element name="IsEncrypted" type="RE:BooleanType" />
            <xs:element name="IsQuotedIdentifierOn" type="RE:BooleanType" />
            <xs:element name="NotForReplication" type="RE:BooleanType" />
            <xs:element name="Delete" type="RE:BooleanType" />
            <xs:element name="Insert" type="RE:BooleanType" />
            <xs:element name="Update" type="RE:BooleanType" />
            <xs:element name="ExecutionContext" type="RE:ExecutionContextType" minOccurs="0" />
          </xs:all>
        </xs:extension>
      </xs:complexContent>
    </xs:complexType>
  </xs:element>
  <xs:element name="ForeignKeyColumn">
    <xs:complexType>
      <xs:complexContent>
        <xs:extension base="MM:InstanceType">
          <xs:all>
            <xs:element name="ReferencedColumn" type="MM:ReferenceType" />
            <xs:element name="ReferencingColumn" type="MM:ReferenceType" />
          </xs:all>
        </xs:extension>
      </xs:complexContent>
    </xs:complexType>
  </xs:element>
  <xs:element name="ForeignKeyConstraint">
    <xs:complexType>
      <xs:complexContent>
        <xs:extension base="MM:InstanceType">
          <xs:all>
            <xs:element name="Parent" type="MM:ReferenceType" />
            <xs:element name="Name" type="xs:string" />
            <xs:element name="Columns" type="MM:ReferencesType" />
            <xs:element name="ReferencedTable" type="MM:ReferenceType" />
            <xs:element name="IsChecked" type="RE:BooleanType" />
            <xs:element name="IsEnabled" type="RE:BooleanType" />
            <xs:element name="NotForReplication" type="RE:BooleanType" />
            <xs:element name="DeleteAction" type="RE:DMLActionEnumeration" />
            <xs:element name="UpdateAction" type="RE:DMLActionEnumeration" />
          </xs:all>
        </xs:extension>
      </xs:complexContent>
    </xs:complexType>
  </xs:element>
  <xs:element name="IndexedColumn">
    <xs:complexType>
      <xs:complexContent>
        <xs:extension base="MM:InstanceType">
          <xs:all>
            <xs:element name="ReferencedColumn" type="MM:ReferenceType" />
            <xs:element name="SortOrder" type="RE:SortOrderEnumeration" />
            <xs:element name="IsIncluded" type="xs:string" />
          </xs:all>
        </xs:extension>
      </xs:complexContent>
    </xs:complexType>
  </xs:element>
  <xs:element name="Login">
    <xs:complexType>
      <xs:complexContent>
        <xs:extension base="MM:InstanceType">
          <xs:all>
            <xs:element name="Name" type="xs:string" />
            <xs:element name="LoginType" type="RE:LoginTypeEnumeration" />
            <xs:element name="Language" type="xs:string" minOccurs="0"/>
          </xs:all>
        </xs:extension>
      </xs:complexContent>
    </xs:complexType>
  </xs:element>
  <xs:element name="PrimaryKeyConstraint">
    <xs:complexType>
      <xs:complexContent>
        <xs:extension base="MM:InstanceType">
          <xs:all>
            <xs:element name="Parent" type="MM:ReferenceType" />
            <xs:element name="Name" type="xs:string" />
            <xs:element name="AssociatedIndex" type="MM:ReferenceType" />
          </xs:all>
        </xs:extension>
      </xs:complexContent>
    </xs:complexType>
  </xs:element>
  <xs:element name="RelationalIndex">
    <xs:complexType>
      <xs:complexContent>
        <xs:extension base="MM:InstanceType">
          <xs:all>
            <xs:element name="Parent" type="MM:ReferenceType" />
            <xs:element name="Name" type="xs:string" />
            <xs:element name="IndexedColumns" type="MM:ReferencesType" />
            <xs:element name="CompactLargeObjects" type="RE:BooleanType" />
            <xs:element name="DisallowPageLocks" type="RE:BooleanType" />
            <xs:element name="DisallowRowLocks" type="RE:BooleanType" />
            <xs:element name="FillFactor" type="RE:FillFactorType" />
            <xs:element name="FilterDefinition" type="xs:string" />
            <xs:element name="IgnoreDuplicateKeys" type="RE:BooleanType" />
            <xs:element name="IndexKey" type="MM:ReferenceType" minOccurs="0" />
            <xs:element name="IsClustered" type="RE:BooleanType" />
            <xs:element name="IsDisabled" type="RE:BooleanType" />
            <xs:element name="IsUnique" type="RE:BooleanType" />
            <xs:element name="MaximumDegreeOfParallelism" type="xs:short" />
            <xs:element name="NoAutomaticRecomputation" type="RE:BooleanType" />
            <xs:element name="OnlineIndexOperation" type="RE:BooleanType" />
            <xs:element name="PadIndex" type="RE:BooleanType" />
            <xs:element name="SortInTempdb" type="RE:BooleanType" />
          </xs:all>
        </xs:extension>
      </xs:complexContent>
    </xs:complexType>
  </xs:element>
  <xs:element name="ScalarParameter">
    <xs:complexType>
      <xs:complexContent>
        <xs:extension base="MM:InstanceType">
          <xs:all>
            <xs:element name="Name" type="xs:string" />
            <xs:element name="DataType" type="RE:DataType" />
            <xs:element name="IsOutput" type="RE:BooleanType" />
            <xs:element name="Nullable" type="RE:BooleanType" />
            <xs:element name="DefaultValue" type="xs:string" minOccurs="0" />
          </xs:all>
        </xs:extension>
      </xs:complexContent>
    </xs:complexType>
  </xs:element>
  <xs:element name="ScalarValuedFunction">
    <xs:complexType>
      <xs:complexContent>
        <xs:extension base="MM:InstanceType">
          <xs:all>
            <xs:element name="Parent" type="MM:ReferenceType" />
            <xs:element name="Name" type="xs:string" />
            <xs:element name="BodyText" type="xs:string" />
            <xs:element name="DataType" type="RE:DataType" />
            <xs:element name="Parameters" type="MM:ReferencesType" minOccurs="0" />
            <xs:element name="ExecutionContext" type="RE:ExecutionContextType" minOccurs="0" />
            <xs:element name="IsEncrypted" type="RE:BooleanType" />
            <xs:element name="IsQuotedIdentifierOn" type="RE:BooleanType" />
            <xs:element name="IsSchemaBound" type="RE:BooleanType" />
            <xs:element name="IsSqlClr" type="RE:BooleanType" />
            <xs:element name="Nullable" type="RE:BooleanType" />
            <xs:element name="ReturnsNullOnNullInput" type="RE:BooleanType" />
          </xs:all>
        </xs:extension>
      </xs:complexContent>
    </xs:complexType>
  </xs:element>
  <xs:element name="Schema">
    <xs:complexType>
      <xs:complexContent>
        <xs:extension base="MM:InstanceType">
          <xs:all>
            <xs:element name="Parent" type="MM:ReferenceType" />
            <xs:element name="Name" type="xs:string" />
            <xs:element name="Owner" type="MM:ReferenceType" minOccurs="0" />
          </xs:all>
        </xs:extension>
      </xs:complexContent>
    </xs:complexType>
  </xs:element>
  <xs:element name="StoredProcedure">
    <xs:complexType>
      <xs:complexContent>
        <xs:extension base="MM:InstanceType">
          <xs:all>
            <xs:element name="Parent" type="MM:ReferenceType" />
            <xs:element name="Name" type="xs:string" />
            <xs:element name="BodyText" type="xs:string" />
            <xs:element name="Parameters" type="MM:ReferencesType" minOccurs="0"  />
            <xs:element name="ExecutionContext" type="RE:ExecutionContextType" minOccurs="0" />
            <xs:element name="ForReplication" type="RE:BooleanType" />
            <xs:element name="IsEncrypted" type="RE:BooleanType" />
            <xs:element name="IsQuotedIdentifierOn" type="RE:BooleanType" />
            <xs:element name="IsRecompiled" type="RE:BooleanType" />
            <xs:element name="IsSqlClr" type="RE:BooleanType" />
            <xs:element name="Startup" type="RE:BooleanType" />
          </xs:all>
        </xs:extension>
      </xs:complexContent>
    </xs:complexType>
  </xs:element>
  <xs:element name="Table">
    <xs:complexType>
      <xs:complexContent>
        <xs:extension base="MM:InstanceType">
          <xs:all>
            <xs:element name="Parent" type="MM:ReferenceType" />
            <xs:element name="Name" type="xs:string" />
            <xs:element name="Columns" type="MM:ReferencesType" />
            <xs:element name="IsQuotedIdentifierOn" type="RE:BooleanType" />
          </xs:all>
        </xs:extension>
      </xs:complexContent>
    </xs:complexType>
  </xs:element>
  <xs:element name="TableParameter">
    <xs:complexType>
      <xs:complexContent>
        <xs:extension base="MM:InstanceType">
          <xs:all>
            <xs:element name="Name" type="xs:string" />
            <xs:element name="DataType" type="RE:DataType" />
          </xs:all>
        </xs:extension>
      </xs:complexContent>
    </xs:complexType>
  </xs:element>
  <xs:element name="TableValuedFunction">
    <xs:complexType>
      <xs:complexContent>
        <xs:extension base="MM:InstanceType">
          <xs:all>
            <xs:element name="Parent" type="MM:ReferenceType" />
            <xs:element name="Name" type="xs:string" />
            <xs:element name="BodyText" type="xs:string" />
            <xs:element name="Columns" type="MM:ReferencesType" />
            <xs:element name="Parameters" type="MM:ReferencesType" minOccurs="0" />
            <xs:element name="ExecutionContext" type="RE:ExecutionContextType" minOccurs="0" />
            <xs:element name="IsEncrypted" type="RE:BooleanType" />
            <xs:element name="IsInline" type="RE:BooleanType" />
            <xs:element name="IsQuotedIdentifierOn" type="RE:BooleanType" />
            <xs:element name="IsSchemaBound" type="RE:BooleanType" />
            <xs:element name="IsSqlClr" type="RE:BooleanType" />
            <xs:element name="TableVariableName" type="xs:string" minOccurs="0" />
          </xs:all>
        </xs:extension>
      </xs:complexContent>
    </xs:complexType>
  </xs:element>
  <xs:element name="UniqueConstraint">
    <xs:complexType>
      <xs:complexContent>
        <xs:extension base="MM:InstanceType">
          <xs:all>
            <xs:element name="Parent" type="MM:ReferenceType" />
            <xs:element name="Name" type="xs:string" />
            <xs:element name="AssociatedIndex" type="MM:ReferenceType" />
          </xs:all>
        </xs:extension>
      </xs:complexContent>
    </xs:complexType>
  </xs:element>
  <xs:element name="User">
    <xs:complexType>
      <xs:complexContent>
        <xs:extension base="MM:InstanceType">
          <xs:all>
            <xs:element name="Parent" type="MM:ReferenceType" />
            <xs:element name="Name" type="xs:string" />
            <xs:element name="UserType" type="RE:UserTypeEnumeration" />
            <xs:element name="Login" type="MM:ReferenceType" minOccurs="0" />
            <xs:element name="DefaultSchema" type="MM:ReferenceType" minOccurs="0" />
          </xs:all>
        </xs:extension>
      </xs:complexContent>
    </xs:complexType>
  </xs:element>
  <xs:element name="UserDefinedDataType">
    <xs:complexType>
      <xs:complexContent>
        <xs:extension base="MM:InstanceType">
          <xs:all>
            <xs:element name="Parent" type="MM:ReferenceType" />
            <xs:element name="Name" type="xs:string" />
            <xs:element name="BaseSystemDataType" type="RE:BaseSystemDataType" />
            <xs:element minOccurs="0" name="Nullable" type="RE:BooleanType" />
          </xs:all>
        </xs:extension>
      </xs:complexContent>
    </xs:complexType>
  </xs:element>
  <xs:element name="UserDefinedTableType">
    <xs:complexType>
      <xs:complexContent>
        <xs:extension base="MM:InstanceType">
          <xs:all>
            <xs:element name="Parent" type="MM:ReferenceType" />
            <xs:element name="Name" type="xs:string" />
            <xs:element name="Columns" type="MM:ReferencesType" />
          </xs:all>
        </xs:extension>
      </xs:complexContent>
    </xs:complexType>
  </xs:element>
  <xs:element name="View">
    <xs:complexType>
      <xs:complexContent>
        <xs:extension base="MM:InstanceType">
          <xs:all>
            <xs:element name="Parent" type="MM:ReferenceType" />
            <xs:element name="Name" type="xs:string" />
            <xs:element name="QueryText" type="xs:string" />
            <xs:element name="Columns" type="MM:ReferencesType" />
            <xs:element name="HasCheckOption" type="RE:BooleanType" />
            <xs:element name="HasColumnSpecification" type="RE:BooleanType" />
            <xs:element name="IsEncrypted" type="RE:BooleanType" />
            <xs:element name="IsQuotedIdentifierOn" type="RE:BooleanType" />
            <xs:element name="IsSchemaBound" type="RE:BooleanType" />
            <xs:element name="ReturnsViewMetadata" type="RE:BooleanType" />
          </xs:all>
        </xs:extension>
      </xs:complexContent>
    </xs:complexType>
  </xs:element>
  <xs:simpleType name="CollationEnumeration">
    <xs:restriction base="xs:string">
      <xs:enumeration value="SQL_Latin1_General_CP437_BIN" />
      <xs:enumeration value="SQL_Latin1_General_CP437_CS_AS" />
      <xs:enumeration value="SQL_Latin1_General_CP437_CI_AS" />
      <xs:enumeration value="SQL_Latin1_General_Pref_CP437_CI_AS" />
      <xs:enumeration value="SQL_Latin1_General_CP437_CI_AI" />
      <xs:enumeration value="SQL_Latin1_General_CP850_BIN" />
      <xs:enumeration value="SQL_Latin1_General_CP850_CS_AS" />
      <xs:enumeration value="SQL_Latin1_General_CP850_CI_AS" />
      <xs:enumeration value="SQL_Latin1_General_Pref_CP850_CI_AS" />
      <xs:enumeration value="SQL_Latin1_General_CP850_CI_AI" />
      <xs:enumeration value="SQL_1Xcompat_CP850_CI_AS" />
      <xs:enumeration value="Latin1_General_BIN" />
      <xs:enumeration value="SQL_Latin1_General_CP1_CS_AS" />
      <xs:enumeration value="SQL_Latin1_General_CP1_CI_AS" />
      <xs:enumeration value="SQL_Latin1_General_Pref_CP1_CI_AS" />
      <xs:enumeration value="SQL_Latin1_General_CP1_CI_AI" />
      <xs:enumeration value="SQL_AltDiction_CP850_CS_AS" />
      <xs:enumeration value="SQL_AltDiction_Pref_CP850_CI_AS" />
      <xs:enumeration value="SQL_AltDiction_CP850_CI_AI" />
      <xs:enumeration value="SQL_Scandinavian_Pref_CP850_CI_AS" />
      <xs:enumeration value="SQL_Scandinavian_CP850_CS_AS" />
      <xs:enumeration value="SQL_Scandinavian_CP850_CI_AS" />
      <xs:enumeration value="SQL_AltDiction_CP850_CI_AS" />
      <xs:enumeration value="Latin1_General_CS_AS" />
      <xs:enumeration value="Latin1_General_CI_AS" />
      <xs:enumeration value="Danish_Norwegian_CS_AS" />
      <xs:enumeration value="Finnish_Swedish_CS_AS" />
      <xs:enumeration value="Icelandic_CS_AS" />
      <xs:enumeration value="Hungarian_BIN" />
      <xs:enumeration value="Albanian_BIN" />
      <xs:enumeration value="Czech_BIN" />
      <xs:enumeration value="SQL_Latin1_General_CP1250_CS_AS" />
      <xs:enumeration value="SQL_Latin1_General_CP1250_CI_AS" />
      <xs:enumeration value="SQL_Czech_CP1250_CS_AS" />
      <xs:enumeration value="SQL_Czech_CP1250_CI_AS" />
      <xs:enumeration value="SQL_Hungarian_CP1250_CS_AS" />
      <xs:enumeration value="SQL_Hungarian_CP1250_CI_AS" />
      <xs:enumeration value="SQL_Polish_CP1250_CS_AS" />
      <xs:enumeration value="SQL_Polish_CP1250_CI_AS" />
      <xs:enumeration value="SQL_Romanian_CP1250_CS_AS" />
      <xs:enumeration value="SQL_Romanian_CP1250_CI_AS" />
      <xs:enumeration value="SQL_Croatian_CP1250_CS_AS" />
      <xs:enumeration value="SQL_Croatian_CP1250_CI_AS" />
      <xs:enumeration value="SQL_Slovak_CP1250_CS_AS" />
      <xs:enumeration value="SQL_Slovak_CP1250_CI_AS" />
      <xs:enumeration value="SQL_Slovenian_CP1250_CS_AS" />
      <xs:enumeration value="SQL_Slovenian_CP1250_CI_AS" />
      <xs:enumeration value="Cyrillic_General_BIN" />
      <xs:enumeration value="Ukrainian_BIN" />
      <xs:enumeration value="Macedonian_FYROM_90_BIN)" />
      <xs:enumeration value="SQL_Latin1_General_CP1251_CS_AS" />
      <xs:enumeration value="SQL_Latin1_General_CP1251_CI_AS" />
      <xs:enumeration value="SQL_Ukrainian_CP1251_CS_AS" />
      <xs:enumeration value="SQL_Ukrainian_CP1251_CI_AS" />
      <xs:enumeration value="Greek_BIN" />
      <xs:enumeration value="SQL_Latin1_General_CP1253_CS_AS" />
      <xs:enumeration value="SQL_Latin1_General_CP1253_CI_AS" />
      <xs:enumeration value="SQL_MixDiction_CP1253_CS_AS" />
      <xs:enumeration value="SQL_AltDiction_CP1253_CS_AS" />
      <xs:enumeration value="SQL_Latin1_General_CP1253_CI_AI" />
      <xs:enumeration value="Turkish_BIN" />
      <xs:enumeration value="SQL_Latin1_General_CP1254_CS_AS" />
      <xs:enumeration value="SQL_Latin1_General_CP1254_CI_AS" />
      <xs:enumeration value="Hebrew_BIN" />
      <xs:enumeration value="SQL_Latin1_General_CP1255_CS_AS" />
      <xs:enumeration value="SQL_Latin1_General_CP1255_CI_AS" />
      <xs:enumeration value="Arabic_BIN" />
      <xs:enumeration value="SQL_Latin1_General_CP1256_CS_AS" />
      <xs:enumeration value="SQL_Latin1_General_CP1256_CI_AS" />
      <xs:enumeration value="SQL_Latin1_General_CP1257_CS_AS" />
      <xs:enumeration value="SQL_Latin1_General_CP1257_CI_AS" />
      <xs:enumeration value="SQL_Estonian_CP1257_CS_AS" />
      <xs:enumeration value="SQL_Estonian_CP1257_CI_AS" />
      <xs:enumeration value="SQL_Latvian_CP1257_CS_AS" />
      <xs:enumeration value="SQL_Latvian_CP1257_CI_AS" />
      <xs:enumeration value="SQL_Lithuanian_CP1257_CS_AS" />
      <xs:enumeration value="SQL_Lithuanian_CP1257_CI_AS" />
      <xs:enumeration value="SQL_Danish_Pref_CP1_CI_AS" />
      <xs:enumeration value="SQL_SwedishPhone_Pref_CP1_CI_AS" />
      <xs:enumeration value="SQL_SwedishStd_Pref_CP1_CI_AS" />
      <xs:enumeration value="SQL_Icelandic_Pref_CP1_CI_AS" />
      <xs:enumeration value="Japanese_BIN" />
      <xs:enumeration value="Japanese_CI_AS" />
      <xs:enumeration value="Korean_Wansung_BIN" />
      <xs:enumeration value="Korean_Wansung_CI_AS" />
      <xs:enumeration value="Chinese_Taiwan_Stroke_BIN" />
      <xs:enumeration value="Chinese_Taiwan_Stroke_CI_AS" />
      <xs:enumeration value="Chinese_PRC_BIN" />
      <xs:enumeration value="Chinese_PRC_CI_AS" />
      <xs:enumeration value="Japanese_CS_AS" />
      <xs:enumeration value="Korean_Wansung_CS_AS" />
      <xs:enumeration value="Chinese_Taiwan_Stroke_CS_AS" />
      <xs:enumeration value="Chinese_PRC_CS_AS" />
      <xs:enumeration value="Thai_BIN" />
      <xs:enumeration value="Thai_CI_AS" />
      <xs:enumeration value="Thai_CS_AS" />
      <xs:enumeration value="SQL_EBCDIC037_CP1_CS_AS" />
      <xs:enumeration value="SQL_EBCDIC273_CP1_CS_AS" />
      <xs:enumeration value="SQL_EBCDIC277_CP1_CS_AS" />
      <xs:enumeration value="SQL_EBCDIC278_CP1_CS_AS" />
      <xs:enumeration value="SQL_EBCDIC280_CP1_CS_AS" />
      <xs:enumeration value="SQL_EBCDIC284_CP1_CS_AS" />
      <xs:enumeration value="SQL_EBCDIC285_CP1_CS_AS" />
      <xs:enumeration value="SQL_EBCDIC297_CP1_CS_AS" />
    </xs:restriction>
</xs:simpleType>
</xs:schema>
Did you find this helpful?
(1500 characters remaining)
© 2013 Microsoft. All rights reserved.