which will fire first ? Trigger or Constraint
Answer Posted / keshavenas
The sequence of execution as follows :
1) before statement level
2) before row level
3) constraint
4) after row level
5) after statement level
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between nested table and varray?
what is a database lock ? : Sql dba
Explain the difference in execution of triggers and stored procedures?
What is normalisation in sql?
What is trigger and how to use it in sql?
What is rename in sql?
Can we rollback after truncate?
what are the authentication modes in sql server? : Sql dba
How do I find duplicates in a single column in sql?
Explain ddl statements in pl/sql?
What are the different types of sql commands?
Can we use pl sql in mysql?
Advantages and disadvantages of stored procedure?
what is difference between delete and truncate commands? : Sql dba
How does postgresql compare to oracle/db2/ms sql server/informix?