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.

See Also

Tasks

How to: Create, Alter, and Remove a Rule in Visual Basic .NET

Reference

Rule

Other Resources

Rules

Help and Information

Getting SQL Server 2005 Assistance