What is a 'instead of trigger'?

Answer Posted / kmbkrishnan

Instead of Trigger is also like the FOR trigger, which
are triggered at that time of Insert or update or delete.
The FOR trigger will be triggering After the
Insert / Update / Delete (DML) opreation is executed. But
the Instead of Trigger will be triggering while the DML
operation held and the DML operation is discarded.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are different joins used in sql?

552


How to create your own reports in sql developer?

540


What are sql procedures?

582


Is time a data type in sql?

480


how to check myisam tables for errors? : Sql dba

599






Is sqlite good enough for production?

531


What is application trigger?

541


Should I use mbr or gpt?

545


What is sequence in sql?

506


Which is faster count (*) or count 1?

541


Is it possible to update views?

540


Which join condition can be specified using on clause?

516


what is difference between delete and truncate commands? : Sql dba

576


What is a recursive join sql?

595


What is procedure and function?

520