27

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?

IEnjoyEatingVegetables
  • 351
  • 1
  • 3
  • 15
Head of Catering
  • 659
  • 2
  • 10
  • 24

1 Answers1

42

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):

Aaron Bertrand
  • 181,950
  • 28
  • 405
  • 624