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).|
|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:
|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.|
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.