Archives of the TeradataForum
Message Posted: Mon, 12 Jan 2004 @ 08:44:16 GMT
I have a requirement to get the hierarchy of all the views which have data selected from another set of views.
Replace view ABC Select * from XYZ;
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|