CODEWITHSUNDEEP
sqlsql-serverssms
user3814197
user3814197

Reputation: 233

Invalid Object Name sql

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')

Upvotes: 15

Views: 138816

Answers (10)

WesleyKmelo
WesleyKmelo

Reputation: 41

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

Upvotes: 0

Md. Zakir Hossain
Md. Zakir Hossain

Reputation: 1092

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

Upvotes: 0

Pixel17
Pixel17

Reputation: 1

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.

Upvotes: 0

hoogw
hoogw

Reputation: 5525

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

Upvotes: 4

Daniel
Daniel

Reputation: 922

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

Upvotes: 1

Phil50
Phil50

Reputation: 71

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

Upvotes: 0

GSK
GSK

Reputation: 31

There might be 2 reasons for it.

  1. Table name is wrong

    Sol: Verify the table name and try to execute

  2. 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])

Upvotes: 2

kamil.ka
kamil.ka

Reputation: 160

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.

Upvotes: 15

Revanth Kumar
Revanth Kumar

Reputation: 837

Try:

Edit -> IntelliSense -> Refresh Local Cache

Upvotes: 26

Sev09
Sev09

Reputation: 883

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.

Upvotes: 37

Related Questions