Rule Editor is placed within the Table Editor dialog. It allows you to modify table rules.
The main element of the editor is the rules list, which displays all the rules in the table and their properties. These properties are as follows:
The name of the rule. It must be different from any other rule name of the same table.
Indicates the kind of statement that activates the rule. It can be SELECT, UPDATE, INSERT or DELETE.
Indicates should rule actions be done instead of statement that activates rule.
Any SQL conditional expression (returning boolean). The condition expression may not refer to any tables except NEW and OLD, and may not contain aggregate functions. NEW is valid in ON INSERT and ON UPDATE rules to refer to the new row being inserted or updated. OLD is valid in ON UPDATE and ON DELETE rules to refer to the existing row being updated or deleted.
Defines comment for rule object.
The command or commands that make up the rule action. Valid commands are SELECT, INSERT, UPDATE, DELETE, or NOTIFY.
The buttons under the list of rules allow you to perform the following actions: