How to change the current value of an auto increment field? Is it possible without dropping the table? Yes it is possible.
In order to do that you have to use SQL command called DBCC CHECKIDENT
Following is the syntax of the DBCC CHECKIDENT command.
table_nameIs the name of the table for which to check the current identity value. The table specified must contain an identity column. Table names must comply with the rules foridentifiers.NORESEEDSpecifies that the current identity value should not be changed.RESEEDSpecifies that the current identity value should be changed.new_reseed_valueIs the new value to use as the current value of the identity column.WITH NO_INFOMSGSSuppresses all informational messages.
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?