how to reset identity c# code example
Example: how to reset the identity column in sql server
USE <databasename>;
GO
DBCC CHECKIDENT ('<tablename>.<columnname>', <value>, <incrementby>);
GO
USE <databasename>;
GO
DBCC CHECKIDENT ('<tablename>.<columnname>', <value>, <incrementby>);
GO