Menu
Home
People
Places
Arts
History
Plants & Animals
Science
Life & Culture
Technology
Reference.org
Database trigger
open-in-new
<p>A database trigger is <a href="/facts/Procedural_code/7r5xz7kx">procedural code</a> that is automatically executed in response to certain <a href="/facts/Event_(computing)/0YdM6AoB">events</a> on a particular <a href="/facts/Table_(database)/5INvK1Vd">table</a> or <a href="/facts/View_(database)/6B00yj6A">view</a> in a <a href="/facts/Database/VYcpkevb">database</a>. The trigger is mostly used for maintaining the <a href="/facts/Database_integrity/g3XGbKIH">integrity</a> 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. </p>