Hinweis
Für den Zugriff auf diese Seite ist eine Autorisierung erforderlich. Sie können versuchen, sich anzumelden oder das Verzeichnis zu wechseln.
Für den Zugriff auf diese Seite ist eine Autorisierung erforderlich. Sie können versuchen, das Verzeichnis zu wechseln.
A trigger is an expression that is bound to a table and is invoked when any of the table's records are modified by one of the specified data-modification commands. Triggers can be used to perform any side-effect operations that a database application requires when data is modified. For example, you can use triggers to:
- Log database modifications.
- Enforce referential integrity.
- Create an automatic reorder for a product that is low on stock.
Triggers are created and stored as properties on a specific table. If you remove a table from a database, the triggers associated with that table are deleted. Triggers fire after all other checks, such as validation rules, primary key enforcement, and null value enforcement, are performed. And unlike field- and record-level validation rules, triggers do not fire on buffered data.
See Also
Record-Level Rule Checking | Creating Triggers | Working with Tables | Removing or Deleting Triggers | Modifying Triggers