Allow NULL or Define DEFAULT Value

Giganews Newsgroups
Subject: Allow NULL or Define DEFAULT Value
Posted by:  binder (rgondz…@gmail.com)
Date: 1 Aug 2006

I am designing a new table with a few columns that may or may not have
a value on each row that is inserted.

What issues determine whether to allow a NULL value to be inserted for
that column or define a default value to be used?

I want to think through the repercussions of this decision before I get
into production.

Replies