Removing a Table from a Database Diagram

Remove a table from your database diagram if you do not want it to appear in the diagram. Removing a table does not alter your server database. The table and its relationships to other tables continue to exist in the database.

• If you remove a table that has been changed by either 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 its modified state until you save it or close the last open database diagram, even though the table no longer appears in your diagram.

For example, suppose you add a table to your diagram so that you can copy its column definitions for address data to a new table you are creating. If you cut the column definitions in the existing table instead of copying them, the table would be marked as modified. In this case, you would discard your changes to that table before removing it. However, if you wanted to move those column definitions to your new table and then remove the existing table from your diagram, you would save your changes to the existing table before removing it.

To remove a table from a database diagram