SQL:What is the message "invalid object name" mean?

Question

How can I disappear this error also he is run very well

this what i can't understand what this error show if code run well

Possible duplicate of [sql server invalid object name - but tables are listed in SSMS tables list](https://stackoverflow.com/questions/1362531/sql-server-invalid-object-name-but-tables-are-listed-in-ssms-tables-list) — GSerg, Jun 15 '20 at 06:28
Sometimes this happened after changing the database table and you need to refresh the IntelliSense by Ctrl + Shift + R — Hesam Akbari, Jun 15 '20 at 06:34

score 1 · Answer 1 · answered Jun 15 '20 at 06:25

1

It just means the intellisense in SQL management studio isn't up to date with all your table names etc. If there was a real error it would show when you try to run the code.

You can press Ctrl+Shift+R to get intellisense to refresh with all the latest information about your schema.

answered Jun 15 '20 at 06:25

ADyson

57,178
14
51
63

Thanks Bro for your help that make the error gone – Mostafa Allam Jun 15 '20 at 06:28

score 1 · Answer 2 · answered Jun 15 '20 at 06:26

1

It seems that your queries execute, but the IntelliSense needs to be refreshed. CTRL + SHIFT + R should solve this.

Also discussed here: Invalid Object name but tables are listed in ssms

answered Jun 15 '20 at 06:26

desa

48
8

thanks all that make error gone thanks again – Mostafa Allam Jun 15 '20 at 06:29

SQL:What is the message "invalid object name" mean?

2 Answers2