What are the differences between Database Trigger and
Integrity constraints ?
Answer Posted / rao
main diff is when we use the trigger voilation rules of
trigger body will not affect existing data.but in case of
constrinat will affect the exsting data also.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What is update query?
how many groups of data types? : Sql dba
What is restrict in sql?
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
What is pl sql and why it is used for?
What is plpgsql language?
Which one is better sql or oracle?
How can triggers be used for the table auditing?
What is a clob in sql?
What is the purpose of primary key?
What is sql comments?
When can we use the where clause and the having clause?
What is a constraint? Tell me about its various levels.
Can we create index on primary key?
Is natural join same as inner join?