Invalid Object error returned when using SELECT statement

Question

When trying to select from 'jREwardToysRUs.dbo.MailDetail_198' table from jREwardToysRUs DataBase, I am getting the following error:

Invalid object name 'jREwardToysRUs.dbo.MailDetail_198'

Like below :

select top 10 *
from jREwardToysRUs.dbo.MailDetail_198

but giving [], the error is gone.Like:

select top 10 *
from [jREwardToysRUs.dbo.MailDetail_198]

Please suggest. how to remove error while selecting only with table name?

When quoting objects in SQL Server, you need to quote each object separately. So, when using 3 part naming conventions DatabaseName.SchemaName.TableName would become [DatabaseName].[SchemaName].[TableName]. If you encapulate the whole thing, the Query analyser would look for a database object literally called 'DatabaseName.SchemaName.TableName' within the database you are currently connected to. — Thom A
– Thom A ♦, Commented Feb 14, 2018 at 17:09

Eray Balkanli · Accepted Answer · 2018-02-14 16:55:03Z

1

I think you are looking for "use" keyword:

use [jREwardToysRUs]
go

select top 10 * 
from [dbo].[MailDetail_198]

answered Feb 14, 2018 at 16:55

Eray Balkanli

8,05013 gold badges60 silver badges94 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sana01 Over a year ago

No the entire jREwardToysRUs.dbo.MailDetail_198 is the table name. So to use this in SQL,enclose them with [Table Name]. Like below: select top 10 * from [jREwardToysRUs.dbo.MailDetail_198]

Collectives™ on Stack Overflow

Invalid Object error returned when using SELECT statement

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related