Create a trigger on a table to enable checks whenever data is inserted, updated, or deleted.
A trigger is a special type of procedure attached to a table column that goes into effect when a user changes the table. Triggers execute immediately after
data modification statements are completed.
- Select , then choose one of the following:
- Select the table for the new trigger.
- Select Properties.
- From the Table Properties window, select .
You see the Add Trigger wizard.
- Enter the name of the trigger, then select the owner of the trigger.
- In the Trigger type window:
- Select the events, that when executed, will call the trigger.
- Select Update of columns, then select the columns to be updated. If changes are made to any of the selected columns, the trigger executes.
- Enter the SQL statements for the new trigger and related table objects.
- (Optional) Click Summary to verify your selected options.