Microsoft SQL Server Management Studio Refresh IntelliSense Cache

Posted: January 25, 2013 in SQL
Tags: , , ,

When programming in Microsoft’s SQL Server Management Studio (2008), IntelliSense tends to throw notices about invalid object names after adding a new table. This has been annoying me for a long time now and I finally decided to research it. Thankfully I found an easy solution.

CRTL-SHIFT-R

This will clear the IntelliSense cache and it will now pickup any new objects you’ve created in the database.

 

Refresh_Local_Cache

Advertisements
Comments
  1. Glen Berndt says:

    Nice little fix. That problem had been bugging me all morning. šŸ™‚

  2. Gary R says:

    FYI, the option to choose this from the menu only seems to appear when you have a query window open. Just being connected to a database or when working with tables causes the option to be hidden. Once you open an existing procedure or open a new query window, the menu option becomes available again.

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