Create Trigger: Details panel
You use the Create Trigger: Details panel to specify information to define the type of trigger to be created.
Panel and field definitions
- No cascade before
- Defines the trigger as a before trigger.
- After
- Defines the trigger as an after trigger.
- Type
-
- Insert
- The trigger is executed when a row is inserted in the trigger table.
- Delete
- The trigger is executed when a row is deleted from the trigger table.
- Update
- The trigger is executed when a row is updated from the trigger table.
- Columns
- Specifies a list of columns to restrict the execution of an update trigger to updates on the specified columns.
- Name
- Name of the table against which an action causes the trigger to be executed.
- Owner
- Owner of the trigger table.
- Old correlation name
- Correlation name used to reference rows as they were before the triggering SQL operation.
- New correlation name
- Correlation name used to reference rows as they were after the triggering SQL operation.
- Old table identifier
- Temporary table identifier used to reference the complete set of rows as they were before the SQL operation.
- New table identifier
- Temporary table identifier used to reference the complete set of rows as they were after the SQL operation.
- 1. For each modified row
- The trigger option is executed for each modified row of the trigger table.
- 2. Once (After Trigger)
- The trigger action is executed only once for the triggering SQL operation.
Parent panels
Child panels
None.