Table of Contents

Class XmlSchema.XmlSchemaFacet

Namespace
LinqToDB.Tools.DataProvider.SqlServer.Schemas
Assembly
linq2db.Tools.dll

sys.xml_schema_facets (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

Returns a row per facet (restriction) of an xml-type definition (corresponds to sys.xml_types).


See sys.xml_schema_facets.

[Table(Schema = "sys", Name = "xml_schema_facets", IsView = true)]
public class XmlSchema.XmlSchemaFacet
Inheritance
XmlSchema.XmlSchemaFacet
Extension Methods

Properties

FacetID

ID (1-based ordinal) of facet, unique within component-id.

[Column("facet_id")]
[NotNull]
public int FacetID { get; set; }

Property Value

int

IsFixed

1 = Facet has a fixed, prespecified value.

0 = No fixed value. (default)

[Column("is_fixed")]
[NotNull]
public bool IsFixed { get; set; }

Property Value

bool

Kind

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

[Column("kind")]
[NotNull]
public string Kind { get; set; }

Property Value

string

KindDesc

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

[Column("kind_desc")]
[Nullable]
public object? KindDesc { get; set; }

Property Value

object

Value

Fixed, pre-specified value of the facet.

[Column("value")]
[Nullable]
public object? Value { get; set; }

Property Value

object

XmlComponentID

ID of XML component (type) to which this facet belongs.

[Column("xml_component_id")]
[NotNull]
public int XmlComponentID { get; set; }

Property Value

int