show views

Tools
RP
N/A

show views

HI
I am totaly new in Teradata. so plz tell me how to show the views in teradata.
5 REPLIES

Re: show views

Hi,

The HELP command will return all the table and view names.The syntax is

HELP DATABASE database_name

Regards,
Kumar
RP
N/A

Re: show views

actually i m using following command for show the view.

SHOW VIEW name;
but this command is not working properly.might be there is problem in database?
can any body tell me how to change the database from page?
like right now i am working on database MERSI and i want to change the database to URI.

Re: show views


You can do a

SHOW VIEW yourdb.yourview;

That will show view DDL even if it's on a different DB

to change default DB to URI, use the command

DATABASE URI;

(this is valid only in the session where it's executed and till it's succeeded by a different DATABASE command )
RP
N/A

Re: show views

Thanks.....

Re: show views

To View the DDL of view this command will work:

show view

To change from one database to another database use

datasbase ;

To check the databsename, which you are at present is

select database;