Archives of the TeradataForum

Message Posted: Fri, 21 Mar 2003 @ 17:28:16 GMT

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

The difference is that if you have a nullable column with a default value, you may insert NULL value. The default value is used, if you don't mention any value.

e.g.

ct tab(col1 int default value 0);

ins tab(null); -> put NULL in table

ins tab(); -> put 0 in table

Regards

Sergio Azzaretti

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