Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 22 Apr 2003 @ 17:04:17 GMT


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


Subj:   Re: Is it possible to modify table?
 
From:   McBride, Michael

You may be correct that it might rewrite the data row for this alter since truncation of the whole number will occur from 13 digits to only 12.

I did not pay close attention to the scale shrinking...I only noticed the 15 going to 18, without accounting for the number of digits to the right of the decimal.

Many times I have done an alter table to go from a smaller number, say DECIMAL(7,2) to a larger number, DECIMAL(10,2) and the change was instantaneous, as in one second response in QueryMan (even on tables loaded with 100 million+ rows)!

mem



     
  <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: 27 Dec 2016