Thread: Reset Identity Column - Microsoft SQL

Reset Identity Column - Microsoft SQL

Sometimes after deleting all the rows in a table you want to get the identity column set to 0 so next row you would add starts at identity column value of 1.

Here is an example sql code that would reset table myTable identity column to 0; so next row you insert would have identity column of 1.

DBCC CHECKIDENT('myTable', RESEED, 0)

Nice, simple tip. Thanks