T-SQL IntelliSense: Some objects or columns don't show up, or are incorrectly marked as invalid

Reasons by T-SQL intellisense does not pickup and complete a list or that an object or column is underlined and marked as incorrect. There could be multiple reasons but I will cover the three most prevalent reasons here:

  • The most common reason is that your local in-memory cache has become stale. Typically this happens if you switch databases, or if you make DDL changes in your query window. Of course if more than one person is actively making changes to the schema will also render your cache stale if someone else has updated the schema while you are already connected to the server. By simply pressing Ctrl+Shift+R or by selecting the menu option Edit > IntelliSense > Refresh Local Cache, you can refresh your local cache, which will reload your metadata and other related resources.

  • The object is a synonym, which is supported in SQL Server 2012.
  • You are on SQL Server 2005 or earlier.

Print | posted @ Thursday, October 3, 2013 8:42 AM

Comments on this entry:

Gravatar # http://ugg-paris.northcoastparks.com
by ugg paris pas cher at 10/20/2013 8:57 AM

You finished specified excellent details there. I did a research on the problem and found practically all individuals will go along with with your weblog.
Post A Comment