SQL Server - reset identity field

Asked Jan 21 '10 at 07:17

Active Jan 21 '10 at 08:08

Viewed 2.7k times

22

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

edited Jan 21 '10 at 07:36

marc_s

732,580
175
1,330
1,459

asked Jan 21 '10 at 07:17

Srinivasan

11,718
30
64
92

1

A similar post: http://stackoverflow.com/questions/510121/ – o.k.w Jan 21 '10 at 07:23

1 Answers1

40

Use DBCC CHECKIDENT:

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

answered Jan 21 '10 at 08:08

Remus Rusanu

288,378
40
442
569

1

The command works in sql server 2014, but you have to put tablename in square brackets ;) : DBCC CHECKIDENT([tablename], RESEED, 0); – Tommy Mar 30 '18 at 10:12