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.

 

Name

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

 

Schema

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

 

Rule Editor - Editing rule definition

 

 

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.