How to: Discard Changes Made to Tables (Visual Database Tools)
To discard unsaved changes to the design of a table you can close the table in Table Designer and choose not to save changes.
To discard unsaved changes
Close the table in Table Designer.
A message prompts you to save your changes. Choose No.
See Also