Removing a Table from a Database Diagram

You can remove a table from your database diagram. Removing a table does not alter your database. The table and its relationships to other tables continue to exist in the database.

If you remove a table that has been changed either by you or another user, a message prompts you to save the table before removing it:

  • If you save the table before removing it, the database is updated with the changes.

  • If you discard changes to the table before removing it, the table remains in memory in its modified state until you save the table or close the last open database diagram, even though the table no longer appears in your diagram.  For more information, see Interactions Among Database Diagrams and Table Design Windows.

To remove a table from a database diagram

  1. In your database diagram, select the table you want to remove.

  2. Right-click the table and choose Remove Table from Diagram from the shortcut menu.

    If the table has unsaved changes as a result of edits you made in the database diagram, a message prompts you to save the table before removing it.

The table is removed from your diagram but it continues to exist in the database.

See Also

Database Designer | Deleting a Table from a Database Diagram and the Database | Tables