3

Possible Duplicate:
Why shouldn't we allow NULLs?

I've heard that it's a bad idea to do database design such that nullable fields exist. However, eliminating nullables often cause much more complex schemas.

Given a schema where elimination of the NULL is considerably more complex (e.g. replace any instance of NULLs with a separate table which gets JOIN'd), or using a nullable field, which is the better action, and why?

Community
  • 1
Billy ONeal
  • 571
  • 2
  • 5
  • 7
  • 3
    See http://dba.stackexchange.com/questions/5222/why-shouldnt-we-allow-nulls. – Nick Chammas Sep 07 '11 at 18:38
  • 1
    Looks like a bit of a duplicate, as far as I see it :-). – Marian Sep 07 '11 at 18:44
  • I'm backing the community on this one. I did speak to the [programmers.se] mods tho at the time of migration, and agreed that it should be migrated. This gives the members of [programmers.se] a link to the final answer tho ;) – jcolebrand Sep 07 '11 at 18:49

0 Answers0