The TableRelation property and SQL Server relationships are automatically synchronized when you create a table and when you redesign a table. However, there are some situations in which you may need to manually synchronize the relationships. Examples include after you have:
Deleted a table in the Object Designer.
Restored a database backup.
Imported a .fob file.
Table relationships are not generated or maintained when you import a .txt file.
To initiate the synchronization process manually
On the File menu, click Database, and then click Alter. The Alter Database window appears.
Click the Integration tab.
Select the Synchronize check box and click OK.
This check box is only enabled when there are table relationships that need to be synchronized because of inconsistencies in the TableRelation property.
If an error occurs during the synchronization process, you receive an error message informing you that a particular table has an invalid relationship. To correct this error, you must modify the TableRelation property of the table in question in the Table Designer and then manually synchronize the relationships again.