What are triggers ?

Triggers

• Special kind of stored procedures that get executed automatically when some DML operation takes place on a table
• can't be invoked on demand
• get triggered only when an associated action (INSERT, UPDATE, DELETE) happens on the table
• used to implement business rules, auditing, referential integrity checks etc.

Referential integrity checks are faster using constraints instead of using Triggers.