|
|
Archives of the TeradataForum
Message Posted: Fri, 02 Jan 2004 @ 14:31:48 GMT
Subj: | | Re: Base Tables in the View |
|
From: | | Judge, James A |
That association does not exist in the standard Teradata dictionary tables. By "standard" I mean DBC tables that are populated WITHOUT any
other Teradata features enabled. I'm thinking that the Qlog (query log) tables of R5 would have this information (but haven't verified at the
moment). Also, if you enable the MDS (Metadata Services) schema of Teradata and run the administrative function to populate those metadata tables
from the "standard" Teradata dictionary tables you could find that relationship in one of the metadata tables. Also, if you use the "query
capture" (Visual Explain - QCD schema) facility, I'm pretty sure that relationship is captured in that schema as well (but not as obvious as the
metadata schema - nor have I positively verified this either).
| |