In a multiuser environment, deleting database objects from the database can affect other users. If another user deletes a database object that appears in your database diagram, the effect of the deletion on your database diagram depends on where the object was deleted.
| Where the object was deleted | How your database diagram is affected |
|---|---|
| In another copy of your database diagram | The deleted object will be removed from your database diagram next time you open it. If your database diagram is open when the deletion occurs, it still shows the deleted item. |
| In a different database diagram | The deleted object will be removed from your database diagram next time you open it. If your database diagram is open when the deletion occurs, it still shows the deleted item. |
| In the database | If your database diagram has no unsaved changes to that object, the object will be removed from your database diagram the next time you open it. If your database diagram contains unsaved changes to that object, the object will remain in your database diagram. You can recreate it in the database by saving your database diagram. |
For example, if the titles table is deleted in the database and you have unsaved changes to the titles table in your database diagram, then saving your database diagram will create a new titles table in the database. Any data that existed in the titles table before it was deleted is not restored.