Reconciling a Database Diagram with a Modified Database

You save your database diagram when you’re ready to update the database to match your diagram. However, if other users updated the database after you opened your diagram, their changes may affect your diagram and vice versa. In such cases, saving your diagram automatically:

• Re-creates database objects that are referenced in your diagram but that another user deleted.
• Preserves triggers that were added to a table; triggers that were deleted from a table are not preserved.
• Deletes an object if you deleted it from your diagram, even if another user edited it.

Saving your diagram reconciles the database with your diagram by overwriting other users’ changes so that the database matches your diagram.

Note If your diagram contains tables and columns that were deleted from the database, only their definitions are re-created in the database when you save your diagram. This process does not restore any data that was stored in these objects prior to their deletion.

To reconcile a database diagram with a modified database