To
specify trigger action settings:
From the Name the Trigger window of the Create Trigger Wizard, click Next. The Choose the Trigger Action Time window will open.
Select one of the following trigger action time options:
To set the trigger to fire after the SQL statement, click the After option button.
To set the trigger to fire before the SQL statement, click the Before option button.
Select one of the following trigger event options:
To choose the INSERT command as the trigger event, choose the Insert option button in the Trigger Event group.
To choose the UPDATE command as the trigger event, choose the Update option button in the Trigger Event group.
To choose the DELETE command as the trigger event, choose the Delete option button in the Trigger Event group.
Select one of the following trigger type options from the Trigger Type field.
Selecting the For each row option button sets the trigger statement to execute on each row modified by the trigger event.
Selecting the For each statement option button sets the trigger statement to execute upon each instance of the trigger event.
If the For each statement option button is selected, clicking Next will open the Specify a WHEN conditionclause window. If the For each row option button is selected, clicking Next will open the Create Trigger Advanced Settings window.
Related topic:
Specifying
Trigger Action Settings
Indicating the Referencing Clause
To indicate the referencing clause
To Specify a WHEN condition
To specify a trigger name and table