All Forums Database
05 Oct 2009
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.

monisiqbal 119 posts Joined 07/09
05 Oct 2009

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

tomnolan 594 posts Joined 01/08
06 Oct 2009

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.

whitestorm2k 8 posts Joined 09/04
21 Oct 2009

Try this:
database database_name;
select * from table_name;

You must sign in to leave a comment.