SQL SERVER – How to Refresh SSMS Intellisense Cache to Update Schema Changes

Have you ever faced situation where you have just created or modified object but SSMS still shows the error. I quite often face this situation where I come across situation where my SSMS Intellisense Cache is not refreshed or updated. This is indeed very frustrating when you are presenting something on stage as the red underline means an error in graved in many people’s minds and it is hard for them to believe when the code with underline runs successfully.

Here is image of the recent situation. Where I had just dropped index but SSMS Intellisense was still showing that the index exists.

refreshintel SQL SERVER   How to Refresh SSMS Intellisense Cache to Update Schema Changes

When I face this kind of situation, without wasting time I immediately do following : CTRL + SHIFT + R . This will clear the cache of the Intellisense and it removes the underline from the word. You can also refresh the Intellisense cache by using Edit -> Intellisense -> Refresh Local Cache.

Here is another question back to you – do you use SSMS Intellisense or any other tool?

Reference: Pinal Dave (http://blog.sqlauthority.com)

22 thoughts on “SQL SERVER – How to Refresh SSMS Intellisense Cache to Update Schema Changes

  1. Good tip although known to me for a while now. I find it extremely annoying when I had just created a table or view and then Intellisense doesn’t recognize it but this should the solution to many developers for this annoyance.

    And yes I do use Intellisense for SSMS; it was a great feature added onto SQL Server 2008 as it makes things a lot faster.


  2. Another great tip Dave! I had always resorted to turning off intellisense in these situations. This is available in a short cut menu by right clicking in the query window; the short cut keys are Ctrl + Q, Ctrl + I.

    I will give the refresh feature a try and it should resolve the problem of turning intellisense back on.

    I primarily use SSMS and I agree with Joker – intellisense is a great added feature that speeds up development.

    Liked by 1 person

  3. Been using SSMS for a long time and was annoyed by this “feature”, obviously not enough to do a search for a resolution until today, works great thanks for the tip.


  4. I find even the refresh doesn’t work a lot of the time in SSMS for 2008 R2. Try creating a table and inserting some rows then refresh the tables list and the intellisense cache – for me it still won’t resolve and I have no intellisense on the new table.
    Back to good ol’ fashioned typing I guess… :-(


  5. Pingback: SQL SERVER – Schema Change Reports – SQL in Sixty Seconds #078 | Journey to SQL Authority with Pinal Dave

  6. Pinal Dave you are a sql GOD! I have been using you for years – not because I looked for your answer but because it is usually the top Google result !!! Before this one I was restarting SSMS after I added objects like some kind of caveman!! Thanks once more!


  7. Wow you are a wealth of information today. That’s two Google searches that hit your pages with the exact right information to solve my issues. Time to bookmark. Thanks for taking the time to present these nuggets of knowledge!


  8. Just used this today – awesome little tip. Makes all the difference in the world. When designing a decent sized project where you’re constantly adding new WCF pieces with corresponding SQL stored procedures, tables, and user defined table variables, having Intellisense work correctly is critical.

    Thanks as always! Even years later, your blogs are still incredibly helpful :-D.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s