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).
| 
