Export (0) Print
Expand All

sys.xml_schema_facets (Transact-SQL)

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:

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.

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft