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