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 does closing a cursor do?

985


what is the difference between delete and truncate statement in sql? : Sql dba

761


What are tables and fields in the database?

752


What is sqlca in db2?

695


What are the different type of joins in sql?

722






Can we commit inside a trigger?

732


What is structural independence and why is it important?

758


How do you remove duplicates without using distinct in sql?

695


How many functions are there in sql?

724


how to rename an existing column in a table? : Sql dba

695


Does truncate remove indexes?

723


Does sql require a server?

711


What are the different ddl commands in sql?

739


Explain correlated query work?

792


What is sql analyzer?

759