SQL Server Performance Forum – Threads Archive
What is DRI in table level permissionWhat is DRI in table level permission
Foreign 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
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.