Trigger are a special kind of SQL statements that are executed on when an event is triggered on the table. These events include INSERT, UPDATE and DELETE. So whenever insert, update or delete operation is performed on the table corresponding trigger get executed.
Types of triggers
There are two types of triggers in SQL.
After trigger gets executed after insert, update or delete operation in performed on the table. On the basis of these operations After trigger is classified in below 3 categories
As the name specifies these triggers get executed instead of executing SQL statement. Suppose an instead of trigger is defined for delete statement so whenever a delete statement is issued for that table, SQL executes instead of triggers and actual delete statement not executes.
Instead of trigger can be classified in following 3 categories based on Insert, update and delete operations