This is an issue that I been wondering about for years, why is there no intellisense for Sql code in Visual Studio (later version). I mean it’s an amazing tool with a lot of useful stuff in it. So how hard could it be… Ok, it’s easy to complain.
Anyway, now there seems to be a Visual studio plug-in on it’s way solving this. Check out SqlAssist! Helps with table names, column names, snippets and more.