Home Forums Database Design Relational Theory Surogate Keys are not always the answer but are freqently used RE: Surogate Keys are not always the answer but are freqently used
Michael Valentine Jones
SSC Guru
Points: 64818
More actions
October 14, 2010 at 3:06 pm
#1237228
Always use Surrogate keys for the primary key. Add unique constraints on all natural keys (alternate keys).
Any other approach will eventually get you in trouble.