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.

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)

About these ads

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

  1. NO, I do not use SSMS intellisense. I have the SQL Developer Bundle from Redgate and I am very happy with it. It is much better than SSMS intellisense.

  2. 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.

  3. 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.

  4. 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.

  5. 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… :-(

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