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
