Using an identity column is particularly suited to use for a primary key when only random values are needed to uniquely identify rows.

Question

Quizplus · Accepted Answer

Identity column values are automatically generated by the system and can be used as a primary key when there is no need for any meaningful information in the key. Since the values are generated randomly, it ensures that each row has a unique identifier.

Using an Identity Column Is Particularly Suited to Use for a Primary