SQL Server - reset identity field [duplicate]

This question already has answers here: Reset AutoIncrement in SQL Server after Delete (14 answers) Closed 9 years ago.

I have a table with a identity column. I need to reset that identity column from zero. What should i开发者_C百科 do for this.

---

Use DBCC CHECKIDENT:

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