Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


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.


Regards,

Prabhjot.



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