27
votes

I am using SQL server 2008. If I am working on the Management Studio's query analyser, and I go ahead and create a new table or view, then the SSMS does not see the newly created object for intellisense.

What do I do to make SSMS see and autosuggest from the newly created tables/views too?

2

2 Answers

59
votes

Have you tried to refresh the intellisense cache

Edit -> Intellisense -> Refresh Local Cache (CTRL+Shift+R)

12
votes

Go to the menus:

Edit > Intellisense > Refresh local cache

or press the shortcut key: Ctrl-Shift-R