I'm searching for a tool or utility that will take views and create a tree structure. My task is develop a comprehensive mapping of my company's inbound and outbound processes. Since a majority of our outbounds are sourced from views an automatic method of generating a tree-like strucutre in text or xml would be a huge help.
I found a post (http://forums.teradata.com/forum/database/query-to-find-out-the-table-name-and-the-columns-of-that-table-associated-with-a-view) that mentions Teradata Utility Pack's Meta Data Services but doesn't explain which function to use or point to any documentation.
Actually most of MDS is a client component that can be easly installed & used from a PC or laptop. One of the features of MDS is that it can provide analysis of Views which includes information on nested views (views that reference views). The MDS web application called MetaSurf provides this type of nested view information as well as providing base table information for views.