Surrogate vs. natural/business keys [closed]

Here we go again, the old argument still arises…

Would we better have a business key as a primary key, or would we rather have a surrogate id (i.e. an SQL Server identity) with a unique constraint on the business key field?

Please, provide examples or proof to support your theory.

19 Answers
19

Leave a Comment