Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SQL Server Management Studio: why when inserting into table, foreign key column is not visible?

It's about SQL Server 2012 Management Studio. I'm training my SQL skills as manually create queries.

Now I want to insert several records in the Users table. As you see there exists a column GroupID, which is a foreign key to another table Groups.

enter image description here

However when I write a query:

insert into Users (Username, Pass, FullName, GroupID)
values ('Tyana', '17890', 'Tyana Stoyanov', 4)

I get an error:

Invalid column name GroupID

enter image description here

Why is that?

like image 816
Todo Avatar asked Jul 14 '13 11:07

Todo


1 Answers

Ctrl + Shift + R is the hotkey to refresh Intellisense. It should fix the problem.

like image 98
Nathan Avatar answered Sep 28 '22 09:09

Nathan