Why created tables are underlined with red despite data display(SQL server )?

Question

0.00/5 (No votes)

See more:

SQL-Server-2012

Hi All
I have created tables which has data, and are displaying correct details upon using the select clause, However the table is being underlined with RED displaying "Invalid object name..." if we bring the cursor near to it.

A similar kind of error occurred while using the creating table syntax, where i used foreign key , the referenced table was being underlined as RED, displaying "There is no primary key in table being referenced..", later i added the Primary key, but the underlined warning was still there and the table creation was done although.

Any ideas on the reasons behind them and how do we resolve it??

What I have tried:

I was wondering if i had the option to attach a screenshot for review:(

Posted 24-Aug-16 0:49am

mousau

Updated 24-Aug-16 0:59am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2016-08-24T00:59:00

Solution 1

Ignore it.
SSMS doesn't refresh it's windows often: I often have queries with red underlines that run and produce the results I want.
If it really bothers you, copy the whole query to the clipboard, open a new query window and paste it in. The underline will vanish because the new query window was loaded with the new table definitions.

Posted 24-Aug-16 0:59am

OriginalGriff

Comments

mousau 24-Aug-16 7:36am

Hi Griff
Thanks for the response.I am accessing sql server 2012 through remote client machine. Tried the mentioned trick, but its not working now.. i assume i gotta logoff and then retry!
Otherwise there are no problems with the results:)
Thank You
Regards