Hello,

In the SQL 2008 R2 GUI for Foreign Key Relationships, it has an "Enforce Foreign Key Constraint" option. What is the equivalent in the "new relationship" builder in DDT v7.6.0?

Reason I'm asking is that the "Enforce relationships for INSERTS AND UPDATES" option in the DDT will disable the delete and update rule comboboxes, but the "Enforce Foreign Key Constraint" in SQL does not disable the "INSERT and UPDATE Specification" options. So I'm confused if they are the same or not.

Thanks.

Yes, they are the same option.  The "Enforce relationship for INSERTs and UPDATEs" option in the DDT is the "Enforce Foreign Key Constraint" option in SQL Server Management Studio.  It basically says whether the constraint is on or off.