title: Resetting the next id in an identity column
body: <p>CourseID is auto incrementing. If I have rows with identities of 16, 17, and 18 and delete all of them, 19 is the next ID generated. I want to set it back to 16 where the last row was deleted.</p>