Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 28 Sep 2011 @ 13:51:25 GMT


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


Subj:   References within Views
 
From:   David Clough

Hi,

Does anyone know of a relatively easy way to derive all the View Names (or Table Names) referenced within a View, by any chance ?

So, if we have a View like this :

     CREATE MYVIEW
     AS
     SEL A.KEY, B.*
     FROM ATABLE A
      INNER JOIN BTABLE B
     WHERE A.KEY= B.KEY
     ;

I want to bring back that MYVIEW references Views/Tables 'ATABLE' and 'BTABLE'

So, basically, I need to explode the Views (or Tables) that make up the definition of MYVIEW.

Any ideas ?


Regards

David Clough
Senior Database Designer
Database Design Group



     
  <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