Disabling a Foreign Key Constraint for Replication

SQL Server supports replication.  Select the option to disable a foreign key constraint during replication if the constraint is specific to the source database and may unnecessarily prevent new data from being entered into the destination database.

To disable a foreign key constraint for replication

1. In your database diagram, right-click the table containing the foreign key, then select Properties from the shortcut menu.

   -or-

   Open the Table Designer for the table containing the foreign key you want to modify, right-click in the Table Designer, and choose Properties from the shortcut menu.

2. Choose the Relationships tab.
   
   
3. Select the relationship from the Selected relationship list.
   
   
4. Clear the Enable relationship for replication check box.

See Also

Constraints | Foreign Key Constraints