How do I reset an increment identity's starting value in SQL Server

sql-server identity
Joel Meador picture Joel Meador · Aug 19, 2008 · Viewed 64.8k times · Source

I would like to have a nice template for doing this in development. How do I reset an increment identity's starting value in SQL Server?

Answer

Ryan Sampson picture Ryan Sampson · Aug 19, 2008 
DBCC CHECKIDENT('TableName', RESEED, 0)

Related questions

Auto increment primary key in SQL Server Management Studio 2012

How do I auto increment the primary key in a SQL Server database table, I've had a look through the forum but can't see how. I've looked the the properties but can't see an option, I have seen an answer …

Read More
How to change identity column values programmatically?

I have a MS SQL 2005 database with a table Test with column ID. ID is an identity column. I have rows in this table and all of them have their corresponding ID auto incremented value. Now I would like to …

Read More
Handling identity columns in an "Insert Into TABLE Values()" statement?

In SQL Server 2000 or above is there anyway to handle an auto generated primary key (identity) column when using a statement like the following? Insert Into TableName Values(?, ?, ?) My goal is to NOT use the column names at all.

Read More