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

  • 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.