sys.xml_schema_facets (Transact-SQL)
Applies to: 
SQL Server
Returns a row per facet (restriction) of an xml-type definition (corresponds to sys.xml_types).
| Column name | Data type | Description |
|---|---|---|
| xml_component_id | int | ID of XML component (type) to which this facet belongs. |
| facet_id | int | ID (1-based ordinal) of facet, unique within component-id. |
| kind | char(2) | Kind of facet: LG = Length LN = Minimum Length LX = Maximum Length PT = Pattern (regular expression) EU = Enumeration IN = Minimum Inclusive value IX = Maximum Inclusive value EN = Minimum Exclusive value EX = Maximum Exclusive value DT = Total Digits DF = Fraction Digits WS = White Space normalization |
| kind_desc | nvarchar (60) | Description of kind of facet: LENGTH MINIMUM_LENGTH MAXIMUM_LENGTH PATTERN ENUMERATION MINIMUM_INCLUSIVE_VALUE MAXIMUM_INCLUSIVE_VALUE MINIMUM_EXCLUSIVE_VALUE MAXIMUM_EXCLUSIVE_VALUE TOTAL_DIGITS FRACTION_DIGITS WHITESPACE_NORMALIZATION |
| is_fixed | bit | 1 = Facet has a fixed, prespecified value. 0 = No fixed value. (default) |
| value | nvarchar (4000) | Fixed, pre-specified value of the facet. |
Permissions
The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. For more information, see Metadata Visibility Configuration.
See Also
Catalog Views (Transact-SQL)
XML Schemas (XML Type System) Catalog Views (Transact-SQL)