Should I use multiple column primary keys or add a new column?
Posted
by
Covar
on Programmers
See other posts from Programmers
or by Covar
Published on 2011-02-07T18:34:58Z
Indexed on
2011/02/08
7:33 UTC
Read the original article
Hit count: 221
database-design
My current database design makes use of a multiple column primary key to use existing data (that would be unique anyway) instead of creating an additional column assigning each entry an arbitrary key. I know that this is allowed, but was wondering if this is a practice that I might want to use cautiously and possibly avoid (much like goto in C).
So what are some of the disadvantages I might see in this approach or reasons I might want a single column key?
© Programmers or respective owner