Table of Contents
Database trigger
Return to Continuous monitoring topics, List of computer science terms, Glossaries, Glossary of programming, Glossary of Databases
“DB trigger” is procedural code that is automatically executed in response to certain events
“Trigger, generally speaking, is the cause of an event. In a database management system (DBMS), a trigger is an SQL procedure that is executed when a record is [added or deleted. It is used to maintain referential integrity in the database. A trigger may also execute a stored procedure. Triggers and stored procedures are built into DBMSs used in client/server environments.”
Fair Use Source: http://www.labautopedia.org/mw/List_of_programming_and_computer_science_terms
- Snippet from Wikipedia: Database trigger
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. Triggers can also be used to log historical data, for example to keep track of employees' previous salaries.
See also
External Sites
- Database trigger