which will fire first ? Trigger or Constraint
Answer Posted / raj dhar
It is depend upon the condition, as if trigger is written
on after insert and update then constraint will fire first
and if you make a trigger as on before insert or update
then the trigger will fire first.
Is This Answer Correct ? | 4 Yes | 5 No |
Post New Answer View All Answers
What are the types of subqueries?
Does truncate remove indexes?
Why primary key is required?
What is sql profiling in oracle?
Explain the working of foreign key?
Explain the working of primary key?
How we can update the view?
How many primary keys can a table have?
Why use truncate instead of delete?
What does the hierarchical profiler does?
define data blocks ? : Sql dba
how to return query output in html format? : Sql dba
Is mariadb nosql?
What is the most common sql injection tool?
What is cursor in pl sql with examples?