All Forums Teradata Applications
Sankalp.C 45 posts Joined 08/13
25 Nov 2013
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?

M.Saeed Khurram 544 posts Joined 09/12
25 Nov 2013

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

Sankalp.C 45 posts Joined 08/13
25 Nov 2013

Thanks! a ton Saeed :)

You must sign in to leave a comment.