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

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

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