Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 18 Nov 2011 @ 07:57:11 GMT


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


Subj:   How to find the associated tables or view in teradata?
 
From:   ravivijay.kumar

Hi All,

How to find the associated tables or view in teradata?

Let us assume, my table name is 'LOT' and view names are 'V1' and 'V2'

I am using my table 'LOT' in view 'V1' and i am using my view 'V1' in view 'V2'.

I just want to find the views associated with the table 'LOT'.If i use the following query,

     select * from dbc.tables
where RequestText like ('%LOT%');

i will be getting only view 'V1'.i wont get the view name 'V2'.In teradata,where internal references are stored?

Can anyone please help me to find out?.I dont want to write the subquery to get the view 'V2'

This is the post I saw in 2008, but i was not able to find any good response...Do we have anything by now?


Thanks & Regards,

Vijay Kumar



     
  <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: 27 Dec 2016