Sql server 2016 intellisense not updating
I hope that gives you some avenues to try if you are finding that Intelli Sense isn't working (partially or at all).And if you've shied away from Intelli Sense in SSMS 2008 or SSMS 2008 R2, I hope you'll give it another shake in SSMS 2012.Another is where the completion list appears, but it does not contain the object(s) you're trying to use.SQL Server 2012 Books Online outlines a variety of other potential issues in the topic Troubleshooting Intelli Sense (SQL Server Management Studio).There are topics for other versions of SQL Server as well: SQL Server 2008 | SQL Server 2008 R2.
There are a couple of different symptoms that can lead you to believe that Intelli Sense is "not working." One is where the Intelli Sense features (auto-complete / list members / tool-tips / underlining invalid references) do not function at all.
For the purpose of this tip, we're going to restrict that to not behaving as designed, as opposed to not behaving as desired (for example, if you don't like that pressing the space bar or tab auto-completes for you, that's a different discussion).
I thought it would be useful to list out the common symptoms and how you can try to resolve them.
In Management Studio 2012, there are some enhancements to Intelli Sense that will make it even more powerful - including more intelligent caching, and partial keyword matching (so you no longer have to remember what letter the waits DMV *starts* with - just type "waits" and it will narrow it down).
I have seen several cases in forums, newsgroups and on twitter where folks complain that Intelli Sense is "not working." Now, "not working" can cover a wide variety of things.where my SSMS Intellisense Cache is not refreshed or updated.