views:

57

answers:

2

Hi, 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?

+1  A: 

Go to the menus:

Edit > Intellisense > Refresh local cache

or press the shortcut key: Ctrl-Shift-R

marc_s
+3  A: 

Have you tried to refresh the intellisense cache

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

R Quijano
Wow, that was nicely tucked away SSMS option :p Thanks!
Saurabh Kumar