Delete a Table from the Database

Delete a table from your database when you want to do all of the following:

• Remove the table from your database diagram.
• Remove the table from every other database diagram in which it appears.
• Mark the table for deletion from the database.

A table that is marked for deletion is permanently deleted from the database when you save your database diagram. A reference to that table continues to exist in memory until you save the database diagram. If you close the database diagram without saving it, the table will continue to exist in your database and appear in your database diagram and every other database diagram in which it appeared before you marked it for deletion.

1. In the Database window, click Database Diagrams   under Objects, click the database diagram you want to open, and then click Design on the Database window toolbar.
2. In your database diagram, select the table you want to delete.
3. Right-click the table and choose Delete Table from Database from the shortcut menu.
4. A message box prompts you to confirm the deletion. Choose Yes.

   Note   Deleting a table automatically removes any relationships to it.