Archives of the TeradataForum

Message Posted: Mon, 26 Feb 2007 @ 09:22:59 GMT


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

Subj:		Re: Alter Table from Datype date to timestamp

From:		D silva, Joseph Vinish

The Alter Table SQL statement applies changes directly to the subject table and does not use the Transient Journal at all.

In the event of some failure the Alter would be continued from the point it left off after re-submission.

That's true for Alter table statement. But the original post was about not being able to alter the data types directly (Date -> Time stamp), so have to go through a phase of add a new column, update it with "converted" values from old col, drop old col, rename new col name to old col name.

So the update is definitely a killer in terms of TJ.

Joseph D'silva