Home Page for the TeradataForum
 
 

 

Archives of the TeradataForum





Message Posted: Wed, 07 Jan 2004 @ 16:30:35 GMT





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




Subj:   Re: Global temp tables
 
From:   Fred W Pluebell



It's not in the standard DBC views, but in DBC.TVM there is a column named "CommitOpt" that contains 'N' for normal tables but 'P' (preserve rows) or 'D' (delete rows) for global temp tables.





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