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

Why are sql stored procedures used?

619


how to see the create table statement of an existing table? : Sql dba

529


how to add a new column to an existing table in mysql? : Sql dba

588


What is data type in database?

550


How many joins in sql?

562






How can I change database name in sql?

533


When is the explicit cursor used ?

594


What are sql ddl commands?

552


how to create a test table in your mysql server? : Sql dba

500


how to fetch common records from two tables? : Sql dba

633


how to use 'mysql' to run sql statements? : Sql dba

539


What is native sql query?

554


What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

556


How to check if a column is nullable before setting to nullable?

589


explain access control lists. : Sql dba

557