There are three action query types that you use in SQL which are INSERT, UPDATE and DELETE. So, there are three types of triggers...
AFTER INSERT Trigger.
AFTER UPDATE Trigger.
AFTER DELETE Trigger.
triggers are classified into two main types:-
1 After Triggers (For Triggers)
2 Instead Of Triggers
There are 2 main types of triggers:
1.After triggers (also known as For triggers.
2.Instead of triggers
1.After triggers further classified into :
2. Instead of triggers further classified into :
a.Instead of Insert.
b. Instead of Update.
c. Instead of Delete.
There are 2 types of triggers. They are
1. DML Triggers ---> a. After trigger b. Instead of trigger
2. DDL Triggers