Name |
Specifies
a name for the object. |
Label |
Specifies a label that is displayed in visual
diagrams. |
Schema |
Shows the relational schema under which this object
was created. |
Action time |
Specifies an action time for the trigger.- BEFORE
- Specifies that the triggered action is
run before any changes are applied
by an insert, delete, or update operation on the subject table.
- AFTER
- Specifies that the associated
triggered action is to be applied after
the changes that are caused by the actual update of the subject table
are
applied to the database.
- INSTEADOF
- Specifies
that the associated triggered action replaces the action against
the subject view. Only one INSTEAD OF trigger is allowed for each
kind of
operation on a given subject view.
|
Granularity |
Specifies
an option for the granularity of the triggered
action. You can select ROW (FOR EACH ROW) or COLUMN (FOR EACH COLUMN). |
Insert |
Specifies
that the trigger action occurs when an INSERT
statement is run on the table or view. For some data servers, you
can only
specify one trigger action. |
Delete |
Specifies that the trigger action occurs when
an DELETE
statement is run on the table or view. For some data servers, you
can only
specify one trigger action. |
Update |
Specifies that the trigger action occurs when
an UPDATE
statement is run on the table or view. For some data servers, you
can only
specify one trigger action. |
Update
columns |
Available only if the Update check
box is selected. In edit mode, 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. |