Applies To: SQL Server 2014, SQL Server 2016 Preview
Returns a row per facet (restriction) of an xml-type definition (corresponds to sys.xml_types).
Applies to: SQL Server (SQL Server 2008 through current version).
ID of XML component (type) to which this facet belongs.
ID (1-based ordinal) of facet, unique within component-id.
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
Description of kind of facet:
1 = Facet has a fixed, prespecified value.
0 = No fixed value. (default)
Fixed, pre-specified value of the facet.
The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.