There are cases where the local cache used by IntelliSense becomes stale. Refreshing the cache is easy but not necessarily obvious. There are two ways to refresh the cache: 1) Go to Edit -> IntelliSense -> Refresh Local Cache and 2) Hit Ctrl+Shift+R
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?
This is the Transact-SQL IntelliSense feature within SQL Server Management Studio.
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.
This was really bugging me also. Always the simple things that save the most time. Many Thanks. JK.
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?