What is the difference between constraints and triggers?
- 9 Answers
- 34190 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / harshad more
Constraints are great at maintaining database integrity for
database fields and relationships between database tables.
Triggers are great for checking past vs. current values and
making decisions based on that data.
In my experience, it is usually much more favorable to use
constraints when possible and leave the trickier business
and auditing logic for use in triggers.
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
What do you understand by the denormalisation?
What is a mutating table error and how can you get around it?
What’s the use of custom fields in report?
What is a periodical index?
What are secondary xml indexes?
How to make a column nullable?
What is dknf in normalization form?
How many columns can we include on clustered index ?
Which table keeps the locking information?
What is a synonym for manipulation?
Explain stored procedure?
Why Master database is required?
Mention the command used to rename the database.
Explain insert into select statement?
How to create nested stored procedure?
