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:(