Archives of the TeradataForum
Message Posted: Tue, 22 Apr 2003 @ 16:21:37 GMT
| Subj: || || Re: Is it possible to modify table? |
| From: || || Chuck McDevitt |
This can't be right:
| ||"This we modify the table header definition automatically and is very quick since it does not rewrite existing rows...."|| |
because decimal(15,2) and decimal(18,6) have a different scale.
To do the conversion, every row would have to be re-written so that the data was shifted 4 dec digits.
If the scale stayed the same, you could do it with just a table header and catalog change.