Archives of the TeradataForum

Message Posted: Thu, 15 Nov 2012 @ 14:26:33 GMT

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

No, this can't be done. Review your class notes.

Basically, the ALTER command cannot be run on a table unless it is possible to rewrite the table headers without touching the data rows. For instance, you could alter decimal(12,0) to decimal(18,0), because these types take the same amount of storage (8 bytes). But you could not alter decimal(7,0) [4 bytes] to decimal(12,0) [8 bytes].

I don't use the ALTER command much. There may be some exceptions to the above rule.

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