Archives of the TeradataForum

Message Posted: Wed, 03 Nov 2004 @ 14:40:15 GMT

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

You can't use ALTER TABLE to change the scale of a DECIMAL column.

Space occupied depends on the precision, so if you copied the data to a new table with the revised column definition then the rows would occupy the same number of bytes.

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