Click here to Skip to main content
15,881,424 members
Articles / Database Development / SQL Server
Tip/Trick

Microsoft SQL Intellisense Not Seeing My Table

Rate me:
Please Sign up or sign in to vote.
5.00/5 (12 votes)
27 Jan 2016CPOL 10.5K   5   5
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)


Written By
Chief Technology Officer SocialVoice.AI
Ireland Ireland
Allen is CTO of SocialVoice (https://www.socialvoice.ai), where his company analyses video data at scale and gives Global Brands Knowledge, Insights and Actions never seen before! Allen is a chartered engineer, a Fellow of the British Computing Society, a Microsoft mvp and Regional Director, and C-Sharp Corner Community Adviser and MVP. His core technology interests are BigData, IoT and Machine Learning.

When not chained to his desk he can be found fixing broken things, playing music very badly or trying to shape things out of wood. He currently completing a PhD in AI and is also a ball throwing slave for his dogs.

Comments and Discussions

 
PraiseMy vote of 5 Pin
Tony D Great28-Jan-16 6:40
Tony D Great28-Jan-16 6:40 
GeneralRe: My vote of 5 Pin
DataBytzAI28-Jan-16 6:42
professionalDataBytzAI28-Jan-16 6:42 
General5 stars Pin
P. Marinov27-Jan-16 22:32
professionalP. Marinov27-Jan-16 22:32 
GeneralMy vote of 5 Pin
Pratik Bhuva27-Jan-16 18:34
professionalPratik Bhuva27-Jan-16 18:34 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.