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.

shamim909
Profile Answers by shamim909 Questions by shamim909
Oct 17th, 2006
14
2651

Questions by shamim909 answers by shamim909

Showing Answers 1 - 14 of 14 Answers

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.