Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Articles / database / SQL-Server

Microsoft SQL Intellisense Not Seeing My Table

5.00/5 (12 votes)
27 Jan 2016CPOL 11.1K  
How to refresh intellisense after adding new objects in Microsoft SQL Management Studio

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….’

Image 1

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

Image 2

History

  • V1 - Jan 27 2016

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)