Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 12 Jul 2006 @ 19:05:19 GMT


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


Subj:   Re: Efficient way to modify column datatype.
 
From:   Bense, Peter

Modify the table, add the new column.

Update the table, setting the new column to the data value in the old column (cast or whatever as necessary).

Modify the table, drop the old column.



     
  <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