Select a table without the owner

Database

Select a table without the owner

I have a table in teradata namely mytable under the owner tduser.

When i try to access the table like "Select * from "mytable"", it says table doesn't exist. But when i do "Select * from tduser.mytable" then it works fine.

What should i do to access the table without providing the owner name??

I logged in as tduser and my table is created under owner tduser.
2 REPLIES
Enthusiast

Re: Select a table without the owner

Your default database may be set as something different from the database/user 'tduser'.

If you set the default database as 'tduser' by running the below command, you can perform the required function.

DATABASE tduser;

Re: Select a table without the owner

Thank u so much.