Name |
Type a name. |
Label |
Type a label. This label is displayed in visual diagrams. |
Schema |
Specify a relational schema under which to create this
object. |
Action time |
Select an action time for the trigger. You can select
BEFORE, AFTER, or INSTEADOF. |
Granularity |
Select an option for the granularity of the triggered
action. You can select ROW (FOR EACH ROW) or COLUMN (FOR EACH COLUMN). |
Insert |
Select to specify that the trigger action occurs when
an INSERT statement is run on the table or view. |
Delete |
Select to specify that the trigger action occurs when
an DELETE statement is run on the table or view. |
Update |
Select to specify that the trigger action occurs when
an UPDATE statement is run on the table or view. |
Update columns |
Available only if you select the Update check
box. Click the ellipsis [...] button to open a window so that you can select
update columns. The grid shows the name and data type for the columns that
you selected. |