Choose Index below for a list of all words and phrases defined in this glossary.


index | Index

Trigger - definition(s)

Trigger : A software device that monitors the values of one or more data elements to detect critical events. A trigger consists of three components : a procedure to check data whenever it changes, a set or range of criterion values or code to determine data integrity or whether a response in called for, and one or more procedures that produce the appropriate response.

[Category=Data Quality ]

Source: Larry English, External, 13-Feb-2009 11:07

These advertisers support this free service

Trigger - A trigger is a special form of stored procedure that goes into effect when you insert, delete, or update a specified table or column. Triggers can be used to enforce referential integrity.

[Category=Data Governance ]

Source: The Data Governance Institute, 28 December 2009 13:23:14, External

trigger - A trigger (from the Dutch trekken, meaning to pull) is a lever which, when pulled by the finger, releases the hammer on a firearm. In a database, a trigger is a set of Structured Query Language (SQL) statements that automatically "fires off" an action when a specific operation, such as changing data in a table, occurs. A trigger consists of an event (an INSERT, DELETE, or UPDATE statement issued against an associated table) and an action (the related procedure). Triggers are used to preserve data integrity by checking on or changing data in a consistent manner.

Related glossary terms: library

[Category=Data Management ]

Source:, 13 September 2013 09:27:35, External


Data Quality Glossary.  A free resource from GRC Data Intelligence. For comments, questions or feedback: