select * from database_name.table_name

Database
Enthusiast

select * from database_name.table_name

Hi ,

I am able to access tables only with the database_name.table_name .

select * from database_name.table_name ;

not able to access table directly .

But online examples , I have seen table names direclty using .Is there a way.

Can I create synonymns??

Regards.
3 REPLIES
Enthusiast

Re: select * from database_name.table_name

When you connect to Teradata, specify default database as the database_name.
Teradata Employee

Re: select * from database_name.table_name

The Teradata Database does not provide synonyms as Oracle does; however, you can create a view in your default database that selects all the columns of the table in a different database.
Enthusiast

Re: select * from database_name.table_name

Try this:
database database_name;
select * from table_name;