Sometimes, we may require to reseed identity column of a table due to various reason. For example we have deleted a record from a Student which have an identity column StudentId. Below is schema Now it has 3 rows as shown below Now suppose we have deleted record 3 which is studentID 3. Now …