SQL Server - reset identity field

Question

Hi,

I have a table with a identity column. I need to reset that identity column from zero. What should i do for this.

Answer 1

Use DBCC CHECKIDENT:

DBCC CHECKIDENT(<tablename>, RESEED, 0);