Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 06 May 2003 @ 13:41:32 GMT


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


Subj:   Re: List of objects used by views
 
From:   Judge, James A

The "manual" way is to type a "SHOW" preceding the query and all the underlying objects are returned (in separate windows when using Queryman). You could "INSERT EXPLAIN" the query into the QCD database (for Visual Explain) and the objects should be in one of the QCD tables (but I am not sure if all "alias" names are completely resolved).

I haven't really investigated any new MDS (5.0 in TTU 7) (metadata services) repository tables to see if that functionality has been added to MDS (but don't think so).



     
  <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