Creating, Altering, and Removing Rules
The document is archived and information here might be outdated

Creating, Altering, and Removing Rules

In SMO, rules are represented by the Rule object. The rule is defined by the TextBody property, which is a text string that contains a condition expression that uses operators or predicates, such as IN, LIKE, or BETWEEN. A rule cannot reference columns or other database objects. Built-in functions that do not reference database objects can be included.

The definition in the TextBody property must contain a variable that refers to the data value entered. Any name or symbol can be used to represent the value when creating the rule, but the first character must be the @ symbol.

© 2016 Microsoft