Facets (SSDL)

Facets in store schema definition language (SSDL) represent constraints on column types that are specified in Property elements. Facets are implemented as XML attributes on Property elements.

The following table describes the facets that are supported in SSDL:

Facet Description

Collation

Specifies the collating sequence (or sorting sequence) to be used when performing comparison and ordering operations on values of the property.

FixedLength

Specifies whether the length of the column value can vary.

MaxLength

Specifies the maximum length of the column value.

Precision

For properties of type Decimal, specifies the number of digits a property value can have. For properties of type Time, DateTime, and DateTimeOffset, specifies the number of digits for the fractional part of seconds of the column value.

Scale

Specifies the number of digits to the right of the decimal point for the column value.

Unicode

Indicates whether the column value is stored as Unicode.

See Also

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

Community Additions

ADD
Show:
© 2015 Microsoft