Post
Ask Question

Reset Auto Identity Column in a SQL Database

Here am explained how to reset autoidentity column in a SQL Database.

Query:
  1. DBCC Checkident('Tablename',RESEED,0)  
Example:
  1. DBCC Checkident('Test',RESEED,0)