Definition

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.

This was last updated in September 2005

Continue Reading About trigger

Dig Deeper on SQL Server Stored Procedures

SearchBusinessAnalytics
SearchDataCenter
SearchDataManagement
SearchAWS
SearchOracle
SearchContentManagement
SearchWindowsServer
Close