Name

[Ielamrani]

I know this is a silly question but I have to ask anyway but I give up.
I typed the following:

SELECT *
FROM dbo_PROV_MASTERS_HCVW

but I am getting this error message:
Invalid object name 'PROV_MASTERS'.

I tried everything: [], "", () and '' but I am getting the same result. How do I solve this problem.
Am I having this problem because of underscore in the name?

thanks in advance

 

[gmmastros]

Is it possible that dbo_PROV_MASTERS_HCVW is a view?

Please copy/paste this to a QA window. Run it, then post the results back here.

select * 
From   Information_Schema.Tables 
Where  Table_Name Like '%prov_masters%'

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[Ielamrani]

I think you're right

this the result


Table_Catalog table_Schema table_Name table_Type
MIS dbo _prov_masters_v VIEW
MIS dbo PROV_MASTERS_HCVW VIEW
MIS dbo PROV_MASTERS2_HCVW VIEW

What do I do from here?
Thanks

 

[SQLDenis]

has to be this

SELECT *
FROM dbo.PROV_MASTERS_HCVW

dbo. not dbo_

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[Ielamrani]

Great, Thank you very much.
I am new to SQL Server and SQL. what dbo stands for?

 

[SQLDenis]

Database owner

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[Ielamrani]

Thank You very much.

 

[SQLBill]

The way to name an object is via four parts:

\\server.database.owner.object

You don't need to use all four. If the database is on the same server as you are using...you don't need the server name. If you are only working in one database, you don't need the database name. If you are working with an object that you own, you don't need the owner name.

In this case, if you had dbo permissions, you wouldn't need the dbo.

-SQLBill

Posting advice: FAQ481-4875

 

[Ielamrani]

Thanks.