Db2-Create Auto Increment Key

How to create Auto Increment Key?

Solution

ALTER TABLE  [TABLE_NAME]

ALTER COLUMN [COLUMN_NAME] SET GENERATED ALWAYS

AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20,

NO MINVALUE, NO MAXVALUE, NO CYCLE, NO ORDER);

COMMIT;

REORG TABLE [TABLE_NAME];

More Questions