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


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


Specifies whether the length of the column value can vary.


Specifies the maximum length of the column value.


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.


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


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

© 2015 Microsoft