How to Change the datatype of an existing Column Of an existing Table.

Teradata Applications
Enthusiast

How to Change the datatype of an existing Column Of an existing Table.

Is there any way to Change the datatype of an existing Column Of an existing Table?

2 REPLIES
Enthusiast

Re: How to Change the datatype of an existing Column Of an existing Table.

Hi,

You can consult the following two topics for this problem:

http://forums.teradata.com/forum/database/how-to-modify-datatype-of-a-column-using-alter-table-comma...

http://forums.teradata.com/forum/database/changing-column-datatype-from-decimal90-to-decimal150

On this second URL, ulrich has provided a work around to change data type of a populated table.

Khurram
Enthusiast

Re: How to Change the datatype of an existing Column Of an existing Table.

Thanks! a ton Saeed :)