db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jakub Jonik" <kub...@gmail.com>
Subject Identity column
Date Wed, 15 Aug 2007 14:10:50 GMT
I am trying to add an Identity column to an existing table with the
following SQL:
ALTER TABLE DummyTable ADD COLUMN DummyColumn GENERATED BY DEFAULT AS
IDENTITY START WITH 1, INCREMENT BY 1.

And I am getting the error:
SQL state 42601: ALTER TABLE statement cannot add an IDENTITY column to a table.

Is there any way to work around this?

Thanks
Jakub

Mime
View raw message