(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Definition
1. A database trigger is procedural code that is automatically executed in response to certain events on a particular table or view in a database. The trigger is mostly used for maintaining the integrity of the information on the database. For example, when a new record (representing a new worker) is added to the employees table, new records should also be created in the tables of the taxes, vacations and salaries.
2. A trigger is a named database object that is associated with a table, and that activates when a particular event occurs for the table. Some uses for triggers are to perform checks of values to be inserted into a table or to perform calculations on values involved in an update.
Abbreviation
Synonyms
Superterms
Subterms
Sources
https://en.wikipedia.org/wiki/Database_trigger (1.); https://dev.mysql.com/doc/refman/5.7/en/triggers.html (2.)
Author: Markus Jödicke
