Posted by Mark D Powell on 03/09/06 03:21

J, I suspect that if you have NULL in the colum or a column of what
should be the natural key to a table that you have bad data or a
non-normalized table.

Fixing bad data is usually easier than fixing bad design.

Adding a surrogate key will do nothing to protect the integrity of the
business data in the columns in question.

Good luck
-- Mark D Powell --

[Back to original message]