Expand Identity Specification and set ( Is Identity) to true.ġ0. Set id to auto-increment by highlighting the id column and going to properties located just below your solution explorer. A new window should be open in the middle pane containing default id column which is set to primary. Navigate again to your SQL server, expand the Database folder, and under your Database right click on the Table Add TableĨ.