Invalid Object Name sql

Question

I keep getting an invalid object name error on my sql code. (member_number, subscriber_policy_number) is underlined with the error message.

The code itself runs fine with no errors, why does this happen? None of the code above this is highlighted

update smmdmm.aid_data
set Member_Number = Subscriber_Policy_Number
where Member_Number in ('000000000','000000001')

Probably you need to refresh the intellisense cache assuming SSMS. — Martin Smith, Jul 07 '14 at 22:44
tried a refresh of the intellisense cache, but had no impact — user3814197, Jul 07 '14 at 23:03
Had the same problem and refreshing intellisense cache as mentioned [here](http://stackoverflow.com/questions/1362531/sql-server-invalid-object-name-but-tables-are-listed-in-ssms-tables-list) worked for me in SSMS. — Aelian, Nov 10 '14 at 17:21
Don't forget to set user's default schema, if you have any schema over tables. — Yusuf Uzun, Sep 03 '16 at 13:05
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) — Baljeet Singh, Nov 04 '19 at 22:02

score 38 · Answer 1 · answered Jul 07 '14 at 23:05

38

Make sure you're using the correct database. It may be defaulting to the "Master" database, and it doesn't look like you have the full schema for the referenced table.

Ex: [DatabaseName].[Schema].[TableName] or [Database1].[smmdmm].[aid_data]

Hope this helps.

answered Jul 07 '14 at 23:05

Sev09

883
2
12
27

2

Thank you. I really appreciate you leaving this answer in this discussion. – Ganesh Kamath - 'Code Frenzy' Oct 04 '17 at 12:25

score 25 · Answer 2 · answered Apr 15 '15 at 23:19

25

Try:

Edit -> IntelliSense -> Refresh Local Cache

answered Apr 15 '15 at 23:19

Revanth Kumar

809
12
18

5

"Ctrl + Shift + r" is a shortcut for this, as well. – Sev09 Dec 16 '16 at 22:48

score 15 · Answer 3 · answered Jun 10 '15 at 10:39

15

According to the error you're receiving I assume that you're using MSSQL.

at the beginning of your queries try:

use [YOUR_DATABASE_NAME];

and then your query. It helped in my case.

answered Jun 10 '15 at 10:39

kamil.ka

150
1
4

Nice and simple for a developer who doesn't use a DB in their normal course of work. Works for me - thanks. – Tom Wilson Sep 02 '15 at 07:48

score 4 · Answer 4 · answered May 10 '17 at 17:08

4

This works for me : Edit -> IntelliSense -> Refresh Local Cache

answered May 10 '17 at 17:08

hoogw

4,982
1
37
33

score 2 · Answer 5 · edited Jun 20 '20 at 09:12

2

There might be 2 reasons for it.

Table name is wrong

Sol: Verify the table name and try to execute
Database name and schema name are not mentioned with the table name in query

Sol: Mention the database and schema name in SQL query.

For ex:

select * from MESQLDBM.dbo.Alert ([DatabaseName].[Schema].[TableName])

edited Jun 20 '20 at 09:12

Community

1
1

answered Feb 26 '16 at 16:37

GSK

31
2

score 1 · Answer 6 · answered Feb 24 '17 at 23:55

1

In my case, I was missing modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();

answered Feb 24 '17 at 23:55

Daniel

920
1
11
22

score 0 · Answer 7 · answered May 03 '16 at 14:49

0

It happened to me in a function and it was a table within that had been dropped long time ago

answered May 03 '16 at 14:49

Phil50

71
1
2

score 0 · Answer 8 · answered Dec 10 '17 at 16:19

0

I came to this page as I kept getting this error each time I ran the program, anyway I found that in the settings my SQL string table name was missing the underscore and should have been as follows; tbl_Customer.

answered Dec 10 '17 at 16:19

Pixel17

1

Is this related to the question in any way? – Nico Haase Dec 10 '17 at 16:27

score 0 · Answer 9 · edited Oct 06 '18 at 19:37

0

I faced case sensitivity problem. Below was my erroneous query

SELECT * FROM [bccci$Biochemical View] AS ibv

here "V"- 1st character of last part of table name is Upper case but in actual table name it was lower case. that is [bccci$Biochemical view]. So my correct code was

SELECT * FROM [bccci$Biochemical view] AS ibv

edited Oct 06 '18 at 19:37

Saim Saddat

38
1
1
8

answered Sep 19 '18 at 09:42

Md. Zakir Hossain

1,082
11
24

score 0 · Answer 10 · answered Nov 24 '22 at 16:35

If you are using VSCode with the mssql plugin, many times the tables you create are not recognized as objects but it is not enough just to update the database.

You need to update the VSCode Intelissense cache.

To do this just close and open VSCode .

The other way is to type the command ctrl+shift+p , which will open the command palette and then type SQL and locate in the MS SQL list: Refresh IntelisSense Cache

Invalid Object Name sql

10 Answers10

Linked