Architecting and designing > Data modeling > The Physical Data Model > Objects in a PDM > Triggers
  
Triggers
Learn about triggers.
Trigger properties
The properties available for trigger definitions vary by DBMS. All properties listed below might not be available.
Insert
The trigger fires when an INSERT command is performed.
Update
The trigger fires when an UPDATE command is performed.
Delete
The trigger fires when a DELETE command is performed.
Of Column
Each specified column name must be a column of the triggering table and appear just one time in the list.
Referencing
Specifies the correlation names for the transition variables and the table names of the transition tables.
Each Row
Select this option if you want the trigger to fire for each row of the table that the INSERT, UPDATE and DELETE commands modify.
Each Statement
Select this option if you want the trigger to fire just one time when the INSERT, UPDATE & DELETE commands are performed.
Trigger Time
Determines whether the trigger fires before or after the action.
When
Specifies a search condition that evaluates to true, false and unknown. The trigger will fire if this condition is true.
Trigger templates
Trigger Template definitions are included in the AUTOEXEC.CSV file, which is installed in the System Architect subdirectory. When System Architect creates a new encyclopedia, the contents of this file are loaded into the new dictionary for that encyclopedia.
To add Trigger Template definitions to the encyclopedia
1 Select Definition > Add, or right-click in the Explorer on Definition > New. Select Trigger Template from the list.
2 Enter a name in the Add Definition dialogue.
3 Type the trigger statements in the Trigger Text field.
Syntax, Description, and Example are optional properties.
4 Click OK.
This graphic is described in the surrounding text.
See also
Objects in a PDM