SQL Server - reset identity field

Asked Jan 21 '10 at 07:17

Active Jan 21 '10 at 08:08

Viewed 2.6k 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

704,970
168
1,303
1,425

asked Jan 21 '10 at 07:17

Srinivasan

11,248
26
61
88

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

281,117
39
423
553

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