Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

Subj:   Re: Base Tables in the View
From:   Singh Sodhi, Prabhjot

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.



  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020