Archives of the TeradataForum

Message Posted: Mon, 12 Jan 2004 @ 08:44:16 GMT

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

Hi James,

I have a requirement to get the hierarchy of all the views which have data selected from another set of views.

For example:

Replace view ABC Select * from XYZ;

And similarly,

Replace view XYZ Select * from 123;

Here both ABC and XYZ are views where as 123 is a table.

I need to get the hierarchy for one of my requests in the following format:

   ABC             XYZ             123

i.e. view XYZ is created from 123 and view ABC is created from XYZ.

Any suggestions are welcome.

Regards,

Prabhjot.

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