The original table is
CREATE TABLE Test (
PK INTEGER NOT NULL GENERATED ALWAYS
AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 2000,
NO MINVALUE, NO MAXVALUE, NO CYCLE, NO ORDER),
COLUMN2 NOT NULL)
When altering the table by adding a column with the wizard, the script generated is
CREATE TABLE Test (
PK INTEGER NOT NULL,
COLUMN2 INTEGER NOT NULL,
COLUMN3 INTEGER NOT NULL)
RESOLUTION
Check the complete script generated.
There will be an alter table like this one in the script:
ALTER TABLE Test
ALTER PK SET GENERATED ALWAYS AS IDENTITY
(START WITH 1
, INCREMENT BY 1
, CACHE 2000
, NO MINVALUE
, NO MAXVALUE
, NO CYCLE
, NO ORDER);
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center