Update SQL Server Management Studio editor window

sql, sql-server-2008, ssms

Solution

As per the comment above - CTRL+SHIFT+R or Edit -> IntelliSense -> Refresh Local Cache work

Problem

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,

Original source