-->

How To: Reset Identity column in SQL Server

Post a Comment

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)

Related Posts

There is no other posts in this category.

Post a Comment

Subscribe Our Newsletter