Labels

Sunday, 27 December 2015

SQL Server - Difference between Identity and Primary Key

The below are the key differences between Identity and Primary Key

S.No                          Identity                                                 Primary Key

1     Identity column values is auto incremented      PK value will be entered by the user

2    Only one identity column per table and             Can be created on more than one column
      created on only one column

No comments:

Post a Comment