undo ssms table designer changes

  • Using SQL Server 2012, Microsoft SQL Server Management Studio    11.0.3156.0

    In the ssms table designer I made changes but decided not to save them, so I closed it and clicked No, don't save.
    But when I right-click the table and choose Design again, it brings back those same changes I started to do before, and there's no apparent way to undo them.
    How do I undo them?

  • There's apparently some kind of time limit on when those changes completely go away after I have close it without saving.
    After waiting a few minutes, now the changes have gone away.  Is there a setting for that somewhere?

  • This is a bit odd, haven't seen this behaviour, can you reproduce this?
    😎
    AFAIK, the table desegner creates DDL scripts (and sometimes selects and inserts) but doesn't store anything anywhere.

  • Yep, it happens every time.  Just happened again.

    Can you verify it doesn't happen to you?  Do you have the same versions of SqlServer and SSMS that I have?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply