Once the table�s in production you can reset, or reseed the column. in other words, you can change the column�s seed value at any time. for instance, you might reseed a column after deleting records or moving data to an archive table.. Execute dbcc checkident (table_name, reseed,new_reseed_value) with new_reseed_value set to the desired starting value. changing the seed value the seed value is the value inserted into an identity column for the very first row loaded into the table.. 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.
Creates an identity column in a table. this property is used with the create table and alter table transact-sql statements. identity columns can be used for generating key values. the identity property on a column guarantees the following: each new value is generated based on the current seed. This is the 51th episode of sql in sixty seconds video and we will see in this episode how to reseed identity of the table column. identity column is every increasing (or decreasing) value based on the interval specified in its property.. 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..
