which will fire first ? Trigger or Constraint
Answer Posted / vikas
Threre is a transaction flow which determine which will
execute first-
Identity
Null
Data type
Instead of trigger
Primary key
check constraint
foreigh key
DML Statement
After trigger
Commit
Write on Disk
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are the two characteristics of a primary key?
What are sql functions? Describe the different types of sql functions?
Do we need commit after truncate?
What is the primary use of normalization?
What is server name sql?
How does index help in query performance?
which types of join is used in sql widely? : Sql dba
how can we know the number of days between two given dates using mysql? : Sql dba
Is there a way to automate sql execution from the command-line, batch job or shell script?
What is normalisation and its types?
Can %notfound return null after a fetch?
What is a Mapplet?
What is a variable in sql?
In what condition is it good to disable a trigger?
What is the difference between a query and a report?