Hello all,
I have a table with "ID" as the primary key and in is an int column.
How do I make this an autoincrement column?
Regards,
Kinyanjui.
Hi Kinyanjui,
You can try
CREATE COLUMN TABLE "TEST" ("ID" bigint NOT NULL primary key GENERATED BY DEFAULT AS IDENTITY);
Regards
Edy
You already have an active moderator alert for this content.
Add comment