What are the types of triggers ?

Answer Posted / vijay

12 types of trigger

SATEMENT LEVEL TRIGGER
1.before insert
2.before update
3.before delete
4.after insert
5.after update
6.after delete

ROW LEVEL TRIGGER
7.before insert
8.before update
9.before delete
10.after insert
11.after update
12.after delete

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the indexing methods?

577


how many ways to get the current time? : Sql dba

530


Why primary key is required?

559


Are sql database names case sensitive?

501


How insert into statements in sql?

595






What does count (*) mean in sql?

1095


What are the various levels of constraints?

668


How do temporal tables work?

521


what is data control language? : Sql dba

588


Is pl sql useful?

543


What is sql key?

525


how many triggers are allowed in mysql table? : Sql dba

559


How do I filter in sql profiler?

538


what is union, minus and interact commands? : Sql dba

666


What is compiled query?

522