Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 17 Feb 2005 @ 13:06:40 GMT


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


Subj:   Re: Where is the DDL for Temporary Tables stored?
 
From:   vimala.cherukuri

The definitions of Global Temporary tables are stored in the dbc table 'tvm', where as the definitions of volatile tables are not stored in the data dictionary.

Volatile tables do not have a persistent definition unlike global temporary tables and must be created each time we need to use them. The table definition is cached only for the duration of the session in which it is created.


Thanks,

Vimala.



     
  <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