How to Reseed Identity Value to start from 0.

52.

DBC CHECKIDEN('myTable', RESEED, 0)

DBCC CHECKIDENT('myTable', RESEED, 0)

DBCC CHECKIDEN('myTable', RESEED, 0)

DBC CHECKIDEN('myTable', RSEED, 0)

DBC CHECKIDENT('myTable', RESED, 0)

If the columns is given as identity. if we delete the rows in that table it start from the deleted rows only. but if we given that line it will again restart from 0 increment.