Skip to content

Latest commit

 

History

History
44 lines (36 loc) · 1.48 KB

enumeration-facets.md

File metadata and controls

44 lines (36 loc) · 1.48 KB
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic helpviewer_keywords
Enumeration Facets
Learn how SQL Server uses enumeration facets to validate XML schemas.
MikeRayMSFT
mikeray
randolphwest
05/05/2022
sql
xml
conceptual
enumeration facets

Enumeration facets

[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance]

[!INCLUDEssNoVersion] rejects XML schemas with types that have pattern facets or enumerations that violate those facets.

Example

The following schema would be rejected, because the featured enumeration value includes a mixed-case value. It would also be rejected because this value violates the pattern value that limits values to only lowercase letters.

CREATE XML SCHEMA COLLECTION MySampleCollection AS '
<schema xmlns="http://www.w3.org/2001/XMLSchema" targetNamespace="http://ns" xmlns:ns="http://ns">
    <simpleType name="MyST">
       <restriction base="string">
          <pattern value="[a-z]*"/>
       </restriction>
    </simpleType>

    <simpleType name="MyST2">
       <restriction base="ns:MyST">
           <enumeration value="mYstring"/>
       </restriction>
    </simpleType>
</schema>';
GO

See also