Reputation: 2726
I was just wondering if someone can help with an annoyance I have with SQL Server Management Studio. When using the query editor it doesn't automatically update when new tables are created.
For example, suppose I create a table and then try to select from that table autocomplete will not find the table and the editor window will show the table as non-existing (i.e. the editor will try to "help" me by saying the table doesn't exist). I was wondering if there was a setting or tweak that can either refresh editors on change or on a time interval.
Any advice will be much appreciated!
Thanks,
Upvotes: 3
Views: 2158
Reputation: 2726
As per the comment above - CTRL+SHIFT+R or Edit -> IntelliSense -> Refresh Local Cache work
Upvotes: 4