Multi column primary key, which column to use as leading edge?
Posted on 2007-03-29
Given SQL SERVER 2000 and table:
CREATE TABLE Person
CityID int not null,
PersonID bigint not null,
WHERE CityID is a FK to Cities table, and PersonID is only unique within a city (Off topic but FYI - the PersonId is imported from another application which does not use globally unique identifiers).
The primary key options are:
My question is which primary key to specify and why/how to figure out which primary key to specify?