Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

Tags:

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 
like image 506
user2145798 Avatar asked Mar 07 '13 20:03

user2145798


People also ask

How do I get rid of the red underline in SQL Server Management Studio?

Try pressing ctrl + Shift + r to refresh intellisense and remove the red squiggly underline.

How do you fix ambiguous column name?

A column name should describe what's in the column. One of the simplest ways to solve an “ambiguous name column” error — without changing column name — is to give the tables you want to join an alias. This sends a clear information to the SQL Machine the columns are different.

How do I change my SSMS color?

Click Options on the Tools menu. Click Environment, and then click Fonts and Colors. In the Show settings for list, select Text Editor. Change the font, size, display item, foreground and background colors.


2 Answers

Have you refreshed your Intellisense cache?

Keyboard shortcut: Ctrl + Shift + R

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

like image 196
Michael Fredrickson Avatar answered Nov 16 '22 08:11

Michael Fredrickson


Go to Edit > IntelliSense > select "Refresh Local Cache".

You need to refresh your cache after you create new tables/add columns/ new views etc

like image 42
rs. Avatar answered Nov 16 '22 10:11

rs.