Clear IntelliSense cache/fixing invalid column name in SSMS

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.


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


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.