| title | Enumeration Facets | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 06/13/2017 | |
| ms.prod | sql-server-2014 | |
| ms.reviewer | ||
| ms.technology | xml | |
| ms.topic | conceptual | |
| helpviewer_keywords |
|
|
| ms.assetid | dec23a79-ddd6-4701-9721-55a2c435a34d | |
| author | MightyPen | |
| ms.author | genemi | |
| manager | craigg |
[!INCLUDEssNoVersion] rejects XML schemas with types that have pattern facets or enumerations that violate those facets.
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
Requirements and Limitations for XML Schema Collections on the Server