Use the Trigger page of the Create Trigger notebook to specify a
trigger's name, its schema, the table on which you want it defined, the
conditions for executing it, and a comment on it.
Fields and controls
Authorities and privileges
To specify a trigger's name, schema, associated table, and
conditions for execution:
- Open the Create Trigger notebook.
- Use the Trigger schema box to specify a
schema for the trigger.
- In the Trigger name field, type a name
for the trigger.
- Use the Table schema box to specify the
schema of the table on which you want to define the trigger.
- Use the Table name box to specify the
table's name.
- Under Time to trigger action, select a
radio button to specify whether the triggered action is to precede or follow
the operation that you select in step 7.
- Under Operation that causes the trigger to be
executed, select a radio button to specify the type of operation
(inserting rows, deleting them, or updating them) that activates the
trigger.
If you select the Update of Columns radio button, and want the
trigger to be executed when specific columns are updated, select these columns
in the box below the button. If you don't select any columns, the
trigger can be executed when any columns are updated.
- Optional: In the Comment field,
document the trigger.
- Click on the Triggered Action tab and specify the action that you want the trigger to
invoke.
Related information