db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <Richard.Hille...@Sun.COM>
Subject Re: Add an identity colum
Date Mon, 21 Sep 2009 18:30:15 GMT
Hi Mike,

Right.

Regards,
-Rick

derby@segel.com wrote:
> 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