Reset Auto Identity Column in a SQL Database

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

Query:

DBCC Checkident('Tablename',RESEED,0)

Example:

DBCC Checkident('Test',RESEED,0)