What is a Database Trigger?

A database trigger is a form of stored procedure which is immediately processed in response to certain events with a database.  A database trigger may allow the user to block any transactions, perform logging as well as modifying data within the database.  Trigger can be classified into two types – the “row” triggers and the “statement” triggers.  “Row” triggers usually occur for every row of a specific table, while “statement” triggers can only be executed once in every INSERT (a new record or input is [...]