Solved: SQL Server Invalid Column name after adding new column

Some times when you add column through SSMS object explorer it will not reflect immediately it

will give you invalid column red mark while you select top n rows in table

/****** Script for SelectTopNRows command from SSMS  ******/

SELECT TOP 1000 [EmpID]
      ,[Empname]
      ,[Emp_Sal]
      ,[IsRepeated]
      ,[status]
      ,[HIREDate]-----------Invalid column Name
  FROM [TBK].[dbo].[Employee_Test]


To solve this kindly follow this steps

• Press CTRL+SHIFT+R
• Go to Edit >> IntelliSense >> Refresh Local Cache