Wednesday, June 16, 2010

How To: Reset Identity column in SQL Server

This is one of those simple tip posts that may seem obvious and taken for granted by those of us who have been working with SQL Server for a while now but maybe a newbie or two out there will find this helpful.

The following line resets the Identity value for the UserTable to ‘0’ so that the next record added starts at 1.

DBCC CHECKIDENT(‘UserTable’ , RESEED, 0)

0 comments:

Post a Comment