Autoincrement not working properly in table
<p>I created a table <code>department</code> with 4 columns and set <code>deparmentid</code> column to autoincrement. Now, after deleting 8 records out of 10, on adding the new record the value of <code>departmentid</code> is shown as 11 instead of 3. I truncated the whole table but again it is showing the same result on inserting the data. What should I do?</p>