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. 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.. Script to reseed tables in sql i have a series of tables that basically need to use two series of seeded values in the identity column the master entries in the tables that we create will start off with identities like below....
Reset identity value. ask question up vote 15 down vote favorite. 4. it will reset the identity value to its original seed value of the table. refer to : sql server how would i reset all of the identity values for a table, and reseed the auto-number in sql server 2008. 2.. Execute dbcc checkident (table_name, noreseed) to determine the current maximum value in the column, and then specify that value as the new_reseed_value in a dbcc checkident (table_name, reseed,new_reseed_value) command.. Current identity value is set to the new_reseed_value. if no rows have been inserted into the table since the table was created, or if all rows have been removed by using the truncate table statement, the first row inserted after you run dbcc checkident uses new_reseed_value as the identity..
No comments:
Post a Comment