cancel
Showing results for 
Search instead for 
Did you mean: 

IDENTITY Column in HDBTABLE

Former Member
0 Kudos

Hi All,

Is there a way to create Identity column in a .hdbtable file using SAP HANA Development perspective? I can create a hdbsequence and use it in my insert statement but is there a way to avoid creating sequences?

Regards,

Piyush

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Yes. Search the CREATE TABLE command for the keyword IDENTITY.

CREATE TABLE - SAP HANA SQL and System Views Reference - SAP Library

Former Member
0 Kudos

Hi John,

The CREATE TABLE Syntax creates a catalogue table where as I am asking about creating a .HDBTABLE file with identity. The .HDBTABLE files are used for transporting the table metadata from one landscape to another.

Regards,

Piyush

former_member182302
Active Contributor
0 Kudos

Hi Piyush,

I think the syntax is not currently supported. May be can give you an update on the current status of supporting the syntax.

Regards,

Krishna Tangudu

Former Member
0 Kudos

Hi guys,

Any solution to this yet? Even I'm hoping for a solution here.

0 Kudos

Hi,

Even I am looking for the same. Any pointers?

Regards,

Bhuvan