Primary Key versus Unique Constraint?

Asked 2008-10-01T16:10:15.770

I'm currently designing a brand new database. In school, we always learned to put a primary key in each table.

I read a lot of articles/discussions/newsgroups posts saying that it's better to use unique constraint (aka unique index for some db) instead of PK.

What's your point of view?

database database-design

Edit Report

1 Answer

posts saying that it's better to use unique constraint (aka unique index for some db) instead of PK

i guess that the only point here is the same old discussion "natural vs surrogate keys", because unique indexes and pk´s are the same thing.

translating:

posts saying that it's better to use natural key instead of surrogate key

answered 2008-10-01T19:02:19.537