23

IntelliSense in SSMS isn't updating unless I shut it down and restart. I've tried disconnecting from the server and reconnecting while the SSMS session is active, but that isn't working.

Steps to recreate:

  1. Create a table
  2. Select something from that table
  3. SSMS displays squiggly red lines under it with the tip "invalid object name"
  4. Execute the query

How can I force IntelliSense to update without restarting SSMS?

36

You need to use this key combination:

CTRL + SHIFT + R

Alternatively, use the menu item:

Edit > IntelliSense > Refresh Local Cache

This article might also be useful (for future readers who have more perplexing IntelliSense issues):

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.