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
