sys.xml_schema_facets (Transact-SQL)

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.

See Also