db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jessica_girl <serhatselcu...@hotmail.com>
Subject Re: Need HELP GUYS :((
Date Thu, 04 Sep 2008 19:02:18 GMT

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.


Mime
View raw message