0

I cant see in table designer fields created via SQL script. If I add new field to designer it warns me about difference detections and lists all added fields via script

Is there any way table designer to display all table's fields no matter if created via designer or query ?

Mike
  • 1,645
  • 3
  • 13
  • 21
Maciej
  • 10,423
  • 17
  • 64
  • 97

1 Answers1

2
  • Close the designer window (not SSMS) without saving
  • reopen it and it should offer to refresh, it will see the changes from your script.
  • Once it has picked up all of the changes, save the designer before making any more changes.
Mike
  • 1,645
  • 3
  • 13
  • 21
  • Indeed, this works. Is there any other option then restarting MS SSMS ? This is quite annoying... Im sure in older versions I didnt have to do that and all changes done by scrips were visible by designers... – Maciej Jun 22 '16 at 06:25
  • I have clarified the answer, it is just the designer window /tab that you need to close not SSMS. Still at least you got there – Mike Jun 22 '16 at 06:29
  • Hi @Maciej, if this is OK now, can you set this question to answered? – Mike Jun 26 '16 at 08:33