but there are some foreing key relations so i can not alter primary keys with alter table alter column restart with
any other recommends :(( Bryan Pendleton wrote: > >> 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 > information to reflect the rows that have been inserted into the table. > > 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.html Sent from the Apache Derby Developers mailing list archive at Nabble.com.