Dan's Blog

I am Principal Program Manager at Microsoft leading the Business Platform Division's (BPD) community team. BPD includes SQL Server, SQL Azure, BizTalk, AppFabric, and other technologies and services.

Refreshing the IntelliSense Cache

Refreshing the IntelliSense Cache

  • Comments 18

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

Leave a Comment
  • Please add 5 and 2 and type the answer here:
  • Post
  • 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?

  • Hi Atul,

    This is the Transact-SQL IntelliSense feature within SQL Server Management Studio.

    Cheers,

    Dan

  • 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?

Page 1 of 2 (18 items) 12