Reset SQL autoincrement

The last modifications of this post were around 2 years ago, some information may be outdated!

Summary

Reset an auto-incrementing columns in a table.

Code

DBCC CHECKIDENT (TABLE_NAME, RESEED, 0)