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. |
Valid |
Available only for existing, read-only, objects,
and not for objects during creation. Shows whether the object is in
a valid state or not. |