Microsoft SQL ServerPrimary Keys


Primary keys are used to uniquely identify a record in a table. A table may only have a single primary key (though the primary key can consist of multiple columns), and a primary key is required for certain types of replication.

Primary keys are often used as (but don't have to be) the clustered index on a table.