Search This Blog

Monday, June 20, 2011

How to reset the Autoincrement column in sql server after DELETE operation

Type the Following Command after the DELETE operation:

DBCC CHECKIDENT ("TABLE NAME", RESEED, 0); --next id will be 1

Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)