Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 14 Dec 2004 @ 11:12:22 GMT


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


Subj:   Re: Finding View information
 
From:   Narayan Murthy

The info about the columns that make up the view can be retrieved either using

- help column <viewname>.<columnname> {to get details of the column provided you knew the column names or use "help view <viewname>" to retrieve your columns, but this may not provide you the column details}

- OR query the tvfields table joining between tvm and tvfields to retrieve all columns that form your view.


But the link that you are asking - reference between the basetable and the view may not be possible - because I think such a relation is not maintained in the dictionary except for the createtext or the requesttext in tvm which is nothing but the DDL associated with the view. I think it is these texts that get used during view resolution and thereby avoiding the kind of relation, that you are looking for.

The way out I think should be Metadata Service.


Narayan



     
  <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