Archives of the TeradataForum

Message Posted: Wed, 17 Sep 2003 @ 13:23:43 GMT

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

Use

alter table mytable add MyCol Default NULL

This will replace the existing default on mytable.mycol with a default of null ... which is the same as if there was no default clause - unless the column is also defined as NOT NULL.

Mike Dempsey
Teradata Client Tools

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