Re: Does it make sense to have 2 unique keys in one table?

In article <44sig8$ggv@ulowell.uml.edu>, dchan@dragon.cpe.ulowell.edu (Empty) says: >does this make sense? > From a logical viewpoint, I would have thought that a unique key is a primary key, and logically there should only be one primary key per table / entity. You might have a need for a two column primary key, but I would then have a single index combining the two columns and define them as the primary key.