Reset auto increment for sql database in mvc 4

Question

this might be a dumb question, but i want to reset my auto-incremented id column in one of my tables after I delete all the rows, how do i do that in a mvc 4 web app?

http://stackoverflow.com/questions/8923114/how-to-reset-auto-increment-in-mysql — Ehsan Sajjad, May 22 '14 at 13:13

D Stanley · Answer 1 · 2014-05-22T13:20:34.147

0

i want to reset my auto-incremented id column in one of my tables after I delete all the rows

Use TRUNCATE TABLE tablename instead of deleting rows - that is much faster and resets the seed for you.

You could also execute the SQL command to reseed an auto-increment field:

 DBCC CHECKIDENT ("tablename", RESEED, 0);

edited May 22 '14 at 13:20

answered May 22 '14 at 13:13

D Stanley

149,601
11
178
240

score 0 · Answer 2 · answered May 22 '14 at 13:14

0

If SQL Server, you can run the command:

dbcc checkident(TableName, 'RESEED', 0)

answered May 22 '14 at 13:14

Brian Mains

50,520
35
148
257

Reset auto increment for sql database in mvc 4

2 Answers2