Archives of the TeradataForum

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

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

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>>