Skip to Content
0

How to set autoincrement primary key in SAP HANA for Business One

Nov 03, 2017 at 07:53 AM

569

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Edy Simon Nov 06, 2017 at 01:15 AM
0

Hi Kinyanjui,

You can try

CREATE COLUMN TABLE "TEST" ("ID" bigint NOT NULL primary key GENERATED BY DEFAULT AS IDENTITY);

Regards

Edy

Share
10 |10000 characters needed characters left characters exceeded