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


Please Help Members By Posting Answers For Below Questions

What company owns postgresql?

560


Why do we go for stored procedures?

507


Is sql dba a good career? : SQL DBA

529


how many values can the set function of mysql take? : Sql dba

530


Difference between table function and pipelined function?

583






What does trigger mean in slang?

523


Why having clause is used in sql?

535


Define select, insert, create, delete, update, drop keywords

596


what is a trigger in mysql? Define different types of trigger. : Sql dba

548


How do I view a view in sql?

504


What is denormalization in a database?

587


Is t sql a programming language?

539


What are instead of triggers?

620


what is the difference between join and union? : Sql dba

545


What is delimiter in pl sql?

582