"Allow nulls" for Foreign key columns
1 posts in topic
Flat View  Flat View

Posted By:   neal_ravindran
Posted On:   Saturday, February 1, 2003 11:29 AM

This is not a JDBC qn...but a DB design qn.

1)Is it a good practice to "allow nulls" for foreign key columns?(I think that could wreak havoc to equi-joins)

2)How would you treat columns with no value for a foreign key column other than "allowing nulls"?

Re: "Allow nulls" for Foreign key columns

Posted By:   Christopher_Koenigsberg  
Posted On:   Monday, February 3, 2003 06:47 AM

Add a new row to the foreign table, representing "none of the above" or whatever, so all the no value/nulls can just reference this key value instead.

About | Sitemap | Contact