db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <de...@segel.com>
Subject RE: Add an identity colum
Date Mon, 21 Sep 2009 17:54:24 GMT

But surely you can rename the old table. Create a new table with the old
name, adding the identity column and then the rest of the columns from the
old table. 

Then in a single select statement enter the old data back to the new table.

No?

> -----Original Message-----
> From: Richard.Hillegas@Sun.COM [mailto:Richard.Hillegas@Sun.COM]
> Sent: Monday, September 21, 2009 8:02 AM
> To: Derby Discussion
> Subject: Re: Add an identity colum
> 
> Hi André,
> 
> Currently, Derby does not let you add an identity column to a table. It
> is a disabled feature. There is an outstanding JIRA for re-enabling this
> capability: DERBY-3888. I suspect that it is not a lot of work. I am
> sure that the community would give you lots of advice if you decided to
> tackle this issue yourself. Alternatively, if enough people vote for
> this issue, it would percolate to the top of our to-do list.
> 
> Thanks,
> -Rick
> 
> André Rothe wrote:
> > Hi,
> >
> > How I can add an identity column to an existing table?
> > I have a datatore where I have to alter some tables. It
> > seems not possible to alter an existing column (datatype
> > integer) into an identity column. Can I add such a
> > new column?
> >
> > Tanks
> > Andre
> >



Mime
View raw message