Database design – Primary Keys

Posted December 10th, 2007 by Eric Webb

This is an interesting article on the selection of a primary key during database design: http://rapidapplicationdevelopment.blogspot.com/2007/08/in-case-youre-new-to-series-ive.html.

I’ve always wondered what the best primary key was and while there are pros and cons for both natural and surrogate keys, it seems that surrogate keys are the way to go.