Sometimes, as when testing a table in a microsoft sql server database, you need to reset an identity column to its initial seed value, typically one.. Using dbcc command "checkident" you can reset the identity value of the column in a table. for example, identity column has 100 as the last identity. if we want next row to have an identity as 201 then you can achieve this using following dbcc command - dbcc checkident (n'tablename', reseed, 34);. In this blog you will learn how to reset identity column values in sql server. in this blog you will learn how to reset identity column values in sql server. here is the sample demonstration for reset identity column value: step 1: create table. create table dbo.emp ( id int identity(1,1), name varchar (10) ) step 2: insert some.
Reset identity column value in sql server. lowell heddings @lowellheddings march 7, 2007, 1:06pm edt. if you are using an identity column on your sql server tables, you can set the next insert value to whatever value you want. an example is if you wanted to start numbering your id column at 1000 instead of 1.. Dbcc checkident can reseed (reset) the identity value of the table. for example, yourtable has 25 rows with 25 as last identity. if we want next record to have identity as 35 we need to run following t sql script in query analyzer. if table has to start with an identity of 1 with the next insert. "to change the original seed value and reseed any existing rows, you must drop the identity column and recreate it specifying the new seed value. when the table contains data, the identity numbers are added to the existing rows with the specified seed and increment values..
