How to generate some ID while inserting data into a table in SAP HANA SQL SCRIPT

[former_member623318]

Hi All,

I have to create a procedure in SAP HANA where I want to generate new column named ID when i am inserting data into xyz table.

In xyz table, I have 3 columns(name,designation,location).

now when i am inserting new column "ID" should add along with name,designation,location.

Regards,

Deepthi

[former_member213277]

Hi,

I assume you are looking for an option to automatically populate unique IDs in an existing column,

please refer this blog IDENTITY column in SAP HANA

Thanks