Refreshing the Intellisense Cache in SSMS 2008+

Intellisense is a new feature that became available in SSMS 2008 onwards. Sometimes i find that intellisense becomes stale and you start getting the squiggly red lines when writing code..even though you are certain the object exists and is correctly spelt.

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

2) Ctrl+Shift+R Shortcut

More details on Intellisense can be found here – http://msdn.microsoft.com/en-us/library/hh245114.aspx

Intellisense shortcuts

image

Advertisements

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

%d bloggers like this: