TechNet
Export (0) Print
Expand All

sys.xml_schema_facets (Transact-SQL)

 

Updated: June 10, 2016

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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 nameData typeDescription
xml_component_idintID of XML component (type) to which this facet belongs.
facet_idintID (1-based ordinal) of facet, unique within component-id.
kindchar(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_descnvarchar (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_fixedbit1 = Facet has a fixed, prespecified value.

0 = No fixed value. (default)
valuenvarchar (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.

Catalog Views (Transact-SQL)
XML Schemas (XML Type System) Catalog Views (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft