Home 2016 January SQL Server: Newly created Table with red underline and showing as an Invalid Object

SQL Server: Newly created Table with red underline and showing as an Invalid Object

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

I created a new table, and immediately I used this table in a query, but I found the table with a red underline and showing that table is invalid.

SQL Server IntelliSense Cache

The solution is,
SQL Server Management Studio IntelliSence Local Cache:

We should refresh IntelliSense Local Cache so that all newly created objects added in the cache and red underline will disappear.

You can refresh the IntelliSense Local Cache from the edit menu of SSMS.

SQL Server IntelliSense Option

Anvesh Patel
SQL Server: Set ROWCOUNT to return only fix number of rows for all Query Result.SQL Server 2012: Custom paging using OFFSET and FETCH NEXT
Comments: 3
  1. Rose
    February 20, 2016 at 1:44 pm

    I don’t even recognize how I ended up here, but I thought this submit was great.
    I do not understand who you happen to be but certainly you will be
    seeing a well-known blogger if you happen to aren’t already.
    Cheers!

  2. August 1, 2016 at 7:40 am

    looks great article.I have also written artilcle related to this. Pls visit
    http://www.techwalkin.com/2012/02/enabling-intellisense-and-refreshing.html

  3. Andres
    February 7, 2019 at 9:39 pm

    I was goin crazy because of red underline. Thank you for your help

Anvesh Patel
Anvesh Patel

Database Engineer

January 23, 2016 SQL Server, , , , , , , , , , , ,