sql server programming: DRI stands for Declarative Referential Integrity which enforces cascade
referential integrity for you. i.e. when you delete a parent row, all children
rows are also deleted (automatically).

However, DRI is fully supported/functional in sql2k and up.


[quoted text, click to view]

DRI means Declarative Referential Integrity which enforces Primary
Key/Foreign Key relationships. The default way to enforce this is just to
not allow a primary key to be updated or deleted if there is referencing
foreign key, but you can optionally choose to cascade the change (the delete
or update) to the foreigh key table. In addition, DRI enforces the behavior
that any insert into the FK table must match a value in the PK table.

The permission you see is for a table with a PK table. To give someone DRI
permission on your table allows them to create a FK in their own table which
references your PK in your table. This has to be explicitly granted,
otherwise anyone could create a FK to your table that kept you from changing
your own data.

I hope this makes sense.

--
HTH
----------------
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com


[quoted text, click to view]

Hello all,

after select a user in the database (using Enterprise Manager
for SQL-Server 7.0), and click Permissions, all objects are listed. All
tables (only) have an option DRI to be selected. What is this column /
property for ???


best regards,
Evandro