Home Page for the TeradataForum
 
 

 

Archives of the TeradataForum





Message Posted: Thu, 02 Oct 2003 @ 11:29:25 GMT





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




Subj:   Re: Importing file into bteq query
 
From:   Dieter Noeth



Ferry, Craig wrote:

  I can't use the CREATE TABLE as syntax because I want to be able to change the primary index on the fly (I didn't find a way to do this with CREATE TABLE).  



Create table new_tab as existing_table with no data primary index(colx);

Be aware that all secondary indexes will be dropped when you specify any index.


Dieter





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