Triggers or DRI

I am using the Upsize Wizard and one of the choices I have to make is to use DRI or triggers to implements constrains. What is the difference and which one is preferable ?

Thank you.
ymailhotAsked:
Who is Participating?
 
Victor SpiridonovConnect With a Mentor Commented:
Trigger is actually a stored procedure, which is automatically fired on one of the following actions performed on the table:DELETE INSERT or UPDATE. DRI is a way to declare relationships between tables at the time, when table is created (declared). They perform the same thing, though trigger gives you  more control, since it allows you to have more functionality. for example, if you use DRI to check, that no orders can be entered for non-existing customers,and you try to insert an order,you will just receive standart error message, if you use trigger, you can create your own error message, and perform some addtional tasks.
0
 
ymailhotAuthor Commented:
Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.