Microsoft SQL Intellisense Not Seeing My Table

Background

If you deal with Microsoft SQL Management Studio, you’ll no doubt have come across the red squiggly line from IntelliSense that says ‘nope, I aiiiiiint got a clue what this is….’

yep – that thing, above ….

What’s happened is that intellisense only seems to get updated when you first load the query window, and is not aware of live changes (seems a bit silly … perhaps there a setting somewhere I haven’t found yet…) … anyway, a colleague gave me this trick a few years ago, and I was reminded of it today.

How To Fix

In the ‘Edit | Intellisense’ menu, locate ‘Refresh local cache’ (or click CTRL + SHIFT + R’, and your new object should appear. #LikeMagic

History

• V1 - Jan 27 2016