Archives of the TeradataForum

Message Posted: Tue, 05 Aug 2008 @ 19:50:19 GMT

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

While altering a non empty table for addition of not null column, you need to specify the default value, Since DATABASE1.TABLE1 is a non empty table you are facing this issue. Also if we try incorporating the same for an empty table then you won't be getting this issue(3559 error).

Check whether the DATABASE2.TABLE1 table contains data. I guess its empty table thats why you didn't face the below error.

Thanks,

Rakesh Saxena.

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