What are the instances when triggers are appropriate?Scenarios for using triggers:
- To create a audit log of database activity.
- To apply business rules.
- To apply some calculation on data from tables which is not stored in them.
- To enforce referential integrity.
- Alter data in a third party application
- To execute SQL statements as a result of an event/condition automatically.