Identity Columns

• Identity columns provide an auto increment value for a table.
  
• The best use of an Identity column is as the primary key for a table.
  
• Identity columns are often of int data type.
  
• To do; set the below properties of the field…
  
  • Identity seed:    Starting value for the field.
    
  • Identity increment:    value by which each automatically assigned value is increment