Archives of the TeradataForum

Message Posted: Tue, 05 Aug 2008 @ 17:37:09 GMT

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

Without more details, a quick guess would be that DATABASE1.TABLE1 has data, whereas DATABASE2.TABLE1 is empty. Adding a not null column to an empty table is not a problem, but if the table has data then a default value must be supplied.

HTH.

JL

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