The Schema Manager displays the Add Validation Rule dialog.
Specify the properties for the validation rule.
If you want, select the rule column(s) for the validation rule by clicking the
Edit
button.
The Validation Rules editor displays the Select Rule Columns dialog.
The available columns are those that have the Validate flag enabled.
Select the column(s) for which the trust level will be downgraded if the condition specified in the WHERE clause for this validation rule is met, and then click
OK
.
If you must use date in a validation rule, then use the
to_date
function and specify the actual format of the date or ensure that the date is specified in the format expected by the database.
Click
OK
.
The Schema Manager adds the new rule to the list of validation rules.
If a base object contains existing data and you change validation rules, you must run the Revalidate job to recalculate trust scores for new and existing data.