Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 13 Dec 2005 @ 22:14:00 GMT


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


Subj:   Re: Parsing DBC.Table's RequesText
 
From:   Dempsey, Mike

You can look at dbc.tvm.CreateText and search for anything of the form "<dbname>"."<tblname>"

Note that this will give you only the directly referenced objects, not tables that are referenced through views, or objects that are referenced thru macros. You would need to make it recursive in order to find those.


Mike Dempsey
Teradata Client Tools



     
  <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