All column names in my view are underlined in red in SSMS

sql-server-2008

Solution

Have you refreshed your Intellisense cache?

Keyboard shortcut: Ctrl + Shift + R

Or, using the menu: `Edit` -> `IntelliSense` -> `Refresh Local Cache`

Problem

I created the view View_DefectDaysOutstanding3. when I select to see the data, it gives the data, but why in the select statement all the fields are underlined in red as error? ``` SELECT TOP 1000 [ID] ,[Severity] ,[AvgDaysOutstanding] ,[ReportMonth] ,[ReportYearMonth] ,[#OfBugs] ,[projid] ,[folderid] FROM [SoftwarePlanner].[dbo].[View_DefectDaysOutstanding3] order by ReportYearMonth ```

Original source

Related problems