Return
-
Title
Generated always as Identity attribute is not handled correctly in case of changes of a table -
Description
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)
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.