which will fire first ? Trigger or Constraint
- 24 Answers
- 47449 Views
- i2, IBM, I also Faced
- E-Mail Answers
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
How do you delete data from a table?
What is trigger in flip flop?
How do you select unique values in sql?
Can we debug stored procedure?
Why cross join is used?
what is a tablespace? : Sql dba
How do you respond to dementia behavior?
What is the difference between nested table and varray?
What is t-sql? : Transact sql
how to write date and time literals? : Sql dba
What is the difference between view and stored procedure?
What normalization means?
Is sql dba a good career? : SQL DBA
What is varchar used for?
How many clustered indexes can you have?
