Why don't you create a new file in production? Do you need to move
data to production as well? If so, I'm also new to Identity columns
(just put in two files with them for the first time). Can you copy
the old file to the new and it knows to not copy the identity columns
and instead starts setting the identity based at your starting number
as defined in the table?
Smith, Mike on Tuesday, October 30, 2012 9:05 AM wrote:
On 30 Oct 2012 10:03, Smith, Mike wrote:
... I was hoping to get the identity values renumbered...
I have a file that I have an auto increment [<ed> IDENTITY] field
in. Currently the file is in development and I would like to clean
up the auto incremented field before it goes to production.
I know its not absolutely necessary, but I'd like to anyway.
I have tried the following "alter table mytable alter column tiid
reset with 1"
I get a message that the alter completed, but I don't see any
difference in the tiid column.
What am I doing wrong with this statement?
Is this there another way to do this?
I'm on V6R1.
This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact