Reset SQL autoincrement

Last modified 12 months ago

Summary

Reset an auto-incrementing columns in a table.

Code 

DBCC CHECKIDENT (TABLE_NAME, RESEED, 0)