Archives of the TeradataForum

Message Posted: Mon, 13 Dec 2004 @ 12:12:41 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Rachana

In SQL Assistant you can run the following SQL:

Help View Viewname; - This will provide you with Column Information

Show View Viewname; - This will show you the DDL of the view

Show Select * from Viewname; - This will show all of the objects that are part of this view including the underlying tables.

Show Qualified Select * from Viewname; - This will show fully-qualified objects including tables.

Hope this helps...

Best Regards

Chris Coffing
AFKS O&M Lead Teradata DBA
Certified Teradata Master

	<Prev	Next>		<<First	<Prev	Next>	Last>>