PingBack from http://www.easycoded.com/refreshing-the-intellisense-cache/

Thanks. Is this with regards to Visual Studio? I don't see a refresh cache option in the menu?

It makes sense to make this a manual refresh, but I'd had yet to come across this option myself when using SSMS 2008.

Hard telling how long might have passed before I noticed that in the menu had I not found this blog post.  I was going nuts trying to figure out why my new tables and sprocs were not 'seen'.

Aye, I looked and looked through the menus and couldn't find anything, but now that this post pointed it out to me, I'm slapping my forehead cause I didn't notice it there. Thanks Dan.

Thank you for your help. Cntrl-Shift + R didn't work for me. Shortcut probably conflicts with one of the installed plugins. Second way worked like a charm.

Got the same answer from some other blog.

http://praveenbattula.blogspot.com/2010/01/refresh-intellisense-local-cache-in-sql.html

This was really bugging me also. Always the simple things that save the most time. Many Thanks. JK.

THANK YOU

How did I miss that?  Thanks for the post!

Thanks, this is a useful thing to know.

Man, thanks a lot.  That was driving me crazy.

Just in case someone stumbles upon this in search of how to refresh the intellisense cache when using Visual Studio to edit SQL, The Edit >> IntelliSense >> Refresh Cache

Keystroke: CTRL + R

Refreshing the cache, in the same logged-in instance of SSMS, did not work for me; i.e., IntelliSense still didn't pick up a new table created in AdventureWorksDW2008R2.

Also, disconnecting & reconnecting the DB Engine also did not work.

What *did* work was exiting SSMS & starting again...voila!...the new table appears in IntelliSense.  Any ideas on what happened?