Category: SQL Server
view more software Tips and Tricks
Updated: 10/28/2012 05:10 AM
Author: Shiju Mathews
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.