Skip to Content
0
Feb 28, 2019 at 01:48 PM

hdbcds syntax for association for creating a foreign key

709 Views

Hi all,

I am struggling with creating foreign key using association in hdbcds. Whatever I tried I either get errors or no foreign key is created.

What would be the syntax in hdbcds file for SQL:

alter table "details" ADD CONSTRAINT "my constraint" foreign key ("header_id") references "header" ("id");

Tables are the following:

header {

key id

}

details {

key id

header_id

}

Many thanks

Anton