Home / Software / Tips and Tricks / How to reset the Identity column is a SQL Server Data table?

How to reset the Identity column is a SQL Server Data table?

Updated:  10/28/2012 05:10 AM
Author:  Shiju Mathews

Status:    Resolved.


When we want to reset the Identity column is a SQL Server Data table use the following script.



Where "[dbo].[tblCustomer]" is the table that is going to reseed.
"0" is the new start seed value.