You save your database diagram when you’re ready to update the database to match your diagram. However, if other users have updated the database since you opened your diagram, their changes might affect your diagram and vice versa. In such cases, saving your diagram will automatically:
Saving your diagram will reconcile the database with your diagram by overwriting other users’ changes so that the database will match your diagram.
To reconcile your diagram with a modified database
If you have not previously saved your diagram, type a name for the diagram in the Save New Database Diagram dialog box and choose OK.
Note If your diagram contains tables and columns that were deleted in the database, only their definitions are recreated 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.