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. |
Permissions
In SQL Server 2005 and later versions, 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.