Question: what is the difference between primary key and identity?
Answer: An identity is simply an auto-increasing column. A primary key is the unique column or columns that define the row. These two are often used together, but there's no requirement that this be so.