Clear IntelliSense cache/fixing invalid column name in SSMS

Posted on by

Clear SSMS IntelliSense Cache

Here’s the issue. You just modified a table and added or changed a column, but now you have that squiggly line when you’re focused on writing queries.

intellisense_before1

The next time you run into this issue, instead of closing off all of your queries and restarting SSMS, there’s a quick keyboard shortcut that is here to save you:

Ctrl + Shift + R

intellisense_after

There we are! Fixed! We’re back in business. This has been something that’s bugged me in the past when working on tables/views/stored procedures, but ever since I found out about this trick it’s made designing databases much easier.

Enjoy!