What is a TriggerA trigger is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data. It is a database object which is bound to a table and is executed automatically. You can’t explicitly invoke . The only way to do this is by performing the required action no the table that they are assigned to.
Types OfThere are three action query types that you use in SQL which are INSERT, UPDATE and DELETE. So, there are three types of and hybrids that come from mixing and matching the events and timings that fire them.
Basically, are classified into two main types:-
(i) After (For )
(ii) Instead Of
(i) AfterThese run after an insert, update or delete on a table. They are not supported for views.
AFTER can be classified further into three types as:
(a) AFTER INSERT Trigger.
(b) AFTER UPDATE Trigger.
(c) AFTER DELETE Trigger.