Wednesday, April 10, 2013

SQl Server- Reset Identity Column in SQL Server

If you deleted all the records from the table and there is an Identity column in your table, You will see that when you insert a new record in your table then Identity column value starts from the last value of that column incremented by your step value.

If you want to start the Identity column value from the seed value after deleting all the record then you must have reset the Identity column value. Here, I am going to show you that how you can reset Identity column value in SQL Server?.

In previous posts, I explained Insert Values into Identity column, Identity Column in SQL Server , STUFF Function, LEN Function, UNICODE Function, LEFT Function, CHARINDEX Function, CHAR Function, ASCII Function, Simple script to backup all SQL Server databases, Table-Valued Parameters and some other articles related to SQL ServerASP.Net, C#.

The following line resets the Identity value for the table so that the next record added starts at your specified seed value.



DBCC CHECKIDENT (yourtable, RESEED, reseedvalue)
--For Example
DBCC CHECKIDENT(' MyTestTable', RESEED, 0)

I hope you enjoyed this tip. I would like to have any feedback from you. Your valuable feedback, question, or comments about this article are always welcome.

No comments:

Post a Comment

If You Enjoyed This Post Please Take 5 Seconds To Share It.

^ Scroll to Top hgpromo