SQL Server Performance Forum – Threads Archive
What is DRI in table level permission
What is DRI in table level permissionForeign keys can ensure that we don’t insert a value in a child table without a matching value in the parent table, and they can insure we don’t delete or change a value in the parent table that would cause records in the child table(s) to be orphaned. What they can’t do, however, is enforce referential integrity across databases or ensure a 1 to n relationship where n is a specific number. Let me note that DRI isn’t just foreign key constraints. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>