SQL Server - reset identity field

Question

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

user_105929 · Answer

Use DBCC CHECKIDENT:

DBCC CHECKIDENT(, RESEED, 0);