Discarding Changes Made in Database Designer or Table Designer

You can discard changes in your database diagram that you do not want to save in the database.

To discard pending modifications

1. Close your database diagram or table design window.
   
   
2. A message prompts you to save your changes. Choose No.

Caution   If you have other open database diagrams or table design windows connected to the same database, the modifications that you discard in this manner remain in your local memory.  To remove these pending modifications from memory, you must close all database diagrams and table design windows connected to the same database.  For more information, see Interactions Among Database Diagrams and Table Design Windows.