Online Documentation for SQL Manager for SQL server

Creating/editing rule

Use the Rule tab of Rule Editor to create/edit a rule and specify its definition.



Enter a name for the new rule, or modify the name of the rule being edited.



Use the drop-down list to select the schema to which the rule belongs.


Rule Editor - Editing rule definition




This area represents the condition(s) that define the rule (condition_expression). This can be any expression valid in a WHERE clause and can include elements such as arithmetic operators, relational operators, and predicates (for example, IN, LIKE, BETWEEN).

Rule definition includes one variable. The at (@) sign precedes each local variable. The expression refers to the value entered with the UPDATE or INSERT statement. Any name or symbol can be used to represent the value when creating the rule, but the first character must be the at (@) sign.