title: SQL Server Auto-increment
body: <p>I am using 3-4 tables and using autoincrement on the primaryk ey in all of them. I want all of the tables to start with 1</p>
  
  <p>For example <code>student</code> table id starts from 1, and <code>Registration</code> table starts from 1.</p>
  
  <p>Right now what happens auto increments start with the last id of student table. For e.g LastRow ID in student table is 100 so <code>Registeration</code> will start from 101. I want it to start from 1 how to do that.</p>