Database Objects Deleted by Another User
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 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 diagram next time you open it. If your 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 diagram next time you open it. If your diagram is open when the deletion occurs, it still shows the deleted item. |
| In the database | If your diagram has no unsaved changes to that object, the object will be removed from your diagram the next time you open it.
If your diagram contains unsaved changes to that object, the object will remain in your diagram. You can recreate it in the database by saving your diagram. |
Note Recreating a deleted object creates a new definition of that object in the database; it does not restore the data that was deleted when the object was deleted.
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 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.
For details about saving a diagram when the database has changed, see Reconciling a Database Diagram with a Modified Database.