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