Skip to Content
avatar image
Former Member

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

Nov 03, 2017 at 07:53 AM | 2k Views

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.

SAP Business One SDK
SAP Business One
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Edy Simon
    Nov 06, 2017 at 01:15 AM

    Hi Kinyanjui,

    You can try

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

    Regards

    Edy

    Add comment
    10|10000 characters needed characters exceeded