Archives of the TeradataForum
Message Posted: Tue, 06 May 2003 @ 13:41:32 GMT
| 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).
| 
