Counter of Festivals

Ashok Blog for SQL Learners and Beginners and Experts

Tuesday, 3 May 2016

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