Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 14 Dec 2006 @ 19:48:42 GMT


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


Subj:   Re: Widen a column length with the ALTER TABLE
 
From:   frank.c.martinez

You can easily make a VARCHAR longer by the alter statement, but you also need to alter the FORMAT at the same time. If you do the ALTER TABLE with just the new VARCHAR size, the FORMAT stays the same. So just issue the ALTER TALBLE with both the new size and a FORMAT with the new size.

iv



     
  <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