which will fire first ? Trigger or Constraint
Answer Posted / vamsi krishna
we can't say which is executed first among the trigger and
constraraint .
the sequence of execution is
(i) before statement level
(ii) before row level
(iii) after row level
(iv) constraint
(v) after statement level
Is This Answer Correct ? | 19 Yes | 8 No |
Post New Answer View All Answers
What are operators available in sql?
What is data control language (dcl)?
Will truncate release space?
Can triggers stop a dml statement from executing on a table?
What are different types of tables in sql?
what are the t string functions available in tsql? : Transact sql
What is a pl/sql block?
how to rename an existing table in mysql? : Sql dba
what is try_catch block in procedure
How do I sort a table in sql?
What are the types of join in sql?
What is right join in sql?
Write an sql query to select all records from the table?
How do I delete a trigger?
What are system versioned tables?