which will fire first ? Trigger or Constraint
Answer Posted / radha sri seshu.kolla
I THINK TRIGGER FIRES FIRST, BCZ WHEN U WRITE A TRIGGER
LIKE 'BEFORE INSERT ON EMP' EVENT. THIS TRIGGER WILL FIRE
IMMEDEATELY BEFORE THE DATA IS ABOUT TO INSERT IN THE
TABLE.WHERE AS IN THE CASE OF CONSTRAINTS, WHEN YOU INSERT
THE DATA,THE DATA GOES FOR CONSTRAINT VALIDATION THEN THE
DATA WILL BE REJECTED(IF THE DATA VIOLATES THE CONSTRAINT
RULE). I AM NOT 100% SURE. THIS IS JUST MY IMAGINATION.
Is This Answer Correct ? | 11 Yes | 5 No |
Post New Answer View All Answers
Can a foreign key have a different name?
how to drop an existing index in mysql? : Sql dba
Write an sql query to select all records from the table?
How delete all data from all tables in sql?
What is procedure and function?
Is sql the best database?
What is forward declaration in pl sql?
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
what is data control language? : Sql dba
What are the packages in pl sql?
how can you see all indexes defined for a table? : Sql dba
What is a temporal table?
How does postgresql compare to oracle/db2/ms sql server/informix?
What is a file delimiter?
What are the two parts of design view?