In a multi-user environment, your database diagram can be affected by changes other users have saved to:
For example, your diagram might contain a table that another user deleted or renamed. In such a case, your diagram will no longer reflect the current state of the database. When you attempt to save your database diagram or selected tables, the Database Changes Detected dialog box notifies you that the database has been updated since you opened your diagram.
This dialog box also displays a list of database objects that will be affected as a result of saving your diagram or selection. At this point, you can take one of these actions:
For example, suppose you edit the au_id
column in the titleauthors
table on your diagram and another user’s diagram contains the authors
table which is related to the titleauthors
table by the au_id
column. Saving your diagram will affect the other user’s diagram. Similarly, suppose that another user defined a check constraint for the qty
column in the sales
table. If you delete the qty
column and save the sales
table, the other user’s check constraint will be affected.
For example, if another user edited a table that you marked for deletion, you may want to research whether the table should be deleted before updating the database.