Archives of the TeradataForum

Message Posted: Wed, 05 Jan 2011 @ 10:39:14 GMT

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

Hi Laxmi Kantha,

We can try rock and roll method.

1- That is rename the current table name to some other name.

2- Crete a new table with the new datatype

3- Then insert the record from the renamed table to the new table

4- Do an Select minus select to ensure the data is correct.

Regards,

Vijay

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