Suppose, I've created a new database DB1 n i've created a table DB1.T1.Now, DESC T1 --> desplaying the table structure butselect * from DB1.T1 ---->giving--> table or view does not exist.. Can any one explain possible reason behind this.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Oct 19th, 2006

 

use only:  select * from t1;

dyaneshwaran

• Nov 1st, 2006

 

bcos Owner names is missing in the select

use

Select * from DB1.dbo.T1

Srinatha Reddy

 Profile Answers by Srinatha Reddy 

• May 20th, 2008

 

Select * from DB1.dbo.T1  is not working .... i tried it

select * from T1 is working.....

pooja_1234

 Profile Answers by pooja_1234 

• Jul 12th, 2008

 

Give Permissions like select , insert ,update ,delete . Use GRANT.

oozaifa

 Profile Answers by oozaifa 

• Nov 6th, 2008

 

Type schema name before table name or your id dont have the access to view the data from that table

todeepakmalhotra

 Profile Answers by todeepakmalhotra Questions by todeepakmalhotra

• Nov 10th, 2008

 

You cannot use the database name before the table name like db1.t1.


we can only use a user name and then table name. eg. let we have a user "deepak" then we can write select * from deepak.t1 .  We can't write select * from db1.t1 coz db1 is a database name not a user name and tables are owned by users not by the database. Database is just the way to store the data.