Refreshing the IntelliSense Cache

  • Article

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

Comments

  • Anonymous
    September 11, 2008
    PingBack from http://www.easycoded.com/refreshing-the-intellisense-cache/

  • Anonymous
    September 14, 2008
    Thanks. Is this with regards to Visual Studio? I don't see a refresh cache option in the menu?

  • Anonymous
    September 16, 2008
    Hi Atul, This is the Transact-SQL IntelliSense feature within SQL Server Management Studio. Cheers, Dan

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

  • Anonymous
    June 05, 2009
    The comment has been removed

  • Anonymous
    July 15, 2009
    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.

  • Anonymous
    December 03, 2009
    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.

  • Anonymous
    January 16, 2010
    Got the same answer from some other blog. http://praveenbattula.blogspot.com/2010/01/refresh-intellisense-local-cache-in-sql.html

  • Anonymous
    March 08, 2010
    This was really bugging me also. Always the simple things that save the most time. Many Thanks. JK.

  • Anonymous
    March 28, 2010
    THANK YOU

  • Anonymous
    May 11, 2010
    How did I miss that?  Thanks for the post!

  • Anonymous
    November 29, 2010
    Thanks, this is a useful thing to know.

  • Anonymous
    December 03, 2010
    The comment has been removed

  • Anonymous
    January 20, 2011
    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

  • Anonymous
    January 23, 2011
    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?

  • Anonymous
    October 12, 2011
    Thanks! I'm sure it's very valuable tip to a lot of us!

  • Anonymous
    November 29, 2011
    Thank you.  I was restarting SMS to get it to work.