Auto increment is used when we want the ID to update itself automatically. Click on the ID column. Ensure that the data type is int and unchecked Allow Nulls Go to the Properties and search for Identity Specification > Is Identity . Choose True then you are done! Thank you for reading and feel free to give your opinion or correct me if there is anything wrong with my post.