Sql management studio intellisense not updating

by |
21-Aug-2015 23:01

4996

Shares

Sql management studio intellisense not updating

The version of SQL Server Management Studio that ships with SQL Server2008 comes with Intelli Sense enabled, I still think Intelli Sense is sometimes more in my way than it is useful but I won’t bore you with that.

What will eventually happen is that if you create new tables and stored procedures Intelli Sense will not know about those, when this happens you have to refresh the local Intelli Sense cache for it to Refresh Local Cache Or you can just hit the CTRL + SHIFT + R shortcut.

Hopefully this will help someone I also created a copy of this on our wiki here: Intelli Sense does not see new objects in SQL Server Management Studio *** Remember, if you have a SQL related question, try our Microsoft SQL Server Programming forum or our Microsoft SQL Server Admin forum Denis has been working with SQL Server since version 6.5.

Although he worked as an ASP/JSP/Cold Fusion developer before the dot com bust, he has been working exclusively as a database developer/architect since 2002.

In addition to English, Denis is also fluent in Croatian and Dutch, but he can curse in many other languages and dialects (just ask the SQL optimizer) He lives in Princeton, NJ with his wife and three kids.

Intelli Sense can be a very powerful ally for the T-SQL developer.

It can significantly reduce keystrokes, prevent you from guessing at object names, make sure you spell them correctly (and use the right case), and can help you understand the interface to several programmable entities such as stored procedures and built-in functions.

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).