Definition: A trigger is a SQL procedure that initiates an action when change (INSERT, DELETE or UPDATE) occurs. Each trigger is attached to a single, specified table in the database. A trigger cannot be called or executed but fires automatically as a result of a data modification to the associated table.

A trigger can be used in any edition and is therefore the preferred method to use for the audit trail.


Need another definition?

Please select from the menu above