Hello,
I guess this question should have been posted to the Derby user list
instead of the development list.
Anyway, can't you reset the value using ALTER TABLE?
Something like this:
ALTER TABLE yourTableName ALTER COLUMN yourColumnName RESTART WITH
theIntegerValueYouWant
Consult the referen
See: http://db.apache.org/derby/docs/10.4/ref/rrefsqlj81859.html
>
> thanks,
>
> bryan
>
> P.S. I think this discussion belongs on derby-user, not derby-dev
>
>
--
View this message in context:
http://www.nabble.com/Need-HELP-GUYS-%3A%28%28-tp19317524p19317754.h
What i should do Derby to update system table values also, especially the
SYS.SYSCOLUMNS.AUTOINCREMENTVALUE column?
I'm somewhat confused by your question, but I think you can use
ALTER TABLE ALTER COLUMN RESTART WITH and
ALTER TABLE ALTER COLUMN INCREMENT BY to adjust the auto-increment
informa
hep me
--
View this message in context:
http://www.nabble.com/Need-HELP-GUYS-%3A%28%28-tp19317524p19317524.html
Sent from the Apache Derby Developers mailing list archive at Nabble.com.