Reset Identity column to zero in SQL Server?

c# sql-server linq-to-sql identity-column
Mohammad Dayyan picture Mohammad Dayyan · Dec 19, 2010 · Viewed 22.7k times · Source

How can I reset the Identity column of a table to zero in SQL Server?

Edit:

How can we do it with LINQ to SQL ?

Answer

Randy Minder picture Randy Minder · Dec 19, 2010 
DBCC CHECKIDENT (MyTable, RESEED, NewValue)

You can also do a Truncate Table, but, of course, that will remove all rows from the table as well.

To do this via L2S:

db.ExecuteCommand("DBCC CHECKIDENT('MyTable', RESEED, NewValue);");

Or, you can call a stored procedure, from L2S, to do it

Related questions

Which SQL Server field type is best for storing price values?

I am wondering what's the best type for a price field in SQL Server for a shop-like structure? Looking at this overview we have data types called money, smallmoney, then we have decimal/numeric and lastly float and real. Name, …

Read More
Type '' in Assembly '' is not marked as serializable. linq-to-sql

I am using asp.net and have configured the sessions to stored in SQL server. My porject has many object and several linq-to-sql dbml's. I have configured all the them to have unidirectional serialization and also made a few customized …

Read More
Linq to SQL DateTime values are local (Kind=Unspecified) - How do I make it UTC?

Isn't there a (simple) way to tell Linq To SQL classes that a particular DateTime property should be considered as UTC (i.e. having the Kind property of the DateTime type to be Utc by default), or is there a …

Read More