declarative referential integrity (DRI) vs. referential in..

Good day,

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

Thanks and brgds

Philipp Post

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

> 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)