which will fire first ? Trigger or Constraint
Answer Posted / suthakar
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 ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do I count rows in sql?
What is Difference Between Unique and Primary Key Constraints?
How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000
Can we join tables without foreign key?
How do you optimize a stored procedure in sql?
what is bdb (berkeleydb)? : Sql dba
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
What is the usage of the distinct keyword?
what are the advantages and disadvantages of views in a database? : Sql dba
What are triggers and its types?
What is the file extension for sql database?
Which is faster union or join?
What is the use of partition by in sql?
What are % type and % rowtype?
What is a record in a database?