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 specific events on a table or view in a database. Triggers are commonly used to maintain data integrity within a database. For example, inserting a new employee record can automatically generate related entries in the tax, vacation, and salary tables. Similarly, triggers enable historical data logging, such as tracking charges to employee salaries over time.
See also
External Sites
- Database trigger