dbTalk Databases Forums  

declarative referential integrity (DRI) vs. referential integrity

comp.databases comp.databases


Discuss declarative referential integrity (DRI) vs. referential integrity in the comp.databases forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Philipp Post
 
Posts: n/a

Default declarative referential integrity (DRI) vs. referential integrity - 03-05-2010 , 08:53 AM






Good day,

Can the both terms “declarative referential integrity” and
“referential integrity” be used interchangeably or are there
differences?

Thanks and brgds

Philipp Post

Reply With Quote
  #2  
Old   
Marco Mariani
 
Posts: n/a

Default Re: declarative referential integrity (DRI) vs. referential integrity - 03-05-2010 , 09:16 AM






On 03/05/2010 03:53 PM, Philipp Post wrote:

Quote:
Can the both terms “declarative referential integrity” and
“referential integrity” be used interchangeably or are there
differences?

A trigger can be used to enforce referential integrity, but contains
procedural code and thus is not declarative. A foreign key or check
constraint, or assertion object, on the other hand, are declarative.

(disclaimer: I Am Not A Database Expert)

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.