Home Page for the TeradataForum
 
 

 

Archives of the TeradataForum





Message Posted: Thu, 05 Sep 2002 @ 14:37:00 GMT





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




Subj:   Re: Revealing underlying sql for teradata views?
 
From:   Richard Perry



Bruce,

The SQL is stored in field 'Requesttext' on table DBC.TVM. An extended version of the SQL can be found in field 'Createtext', this field is only populated for Views.

Richard.





     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
 
  Top Home Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky 
Last Modified: 30 Jun 2008