topic Re: How can I add a foreign key ? in Talend Studio

How can I add a foreign key ?

Eric_Talend — Sat, 16 Nov 2024 01:49:45 GMT

Hello Talend World,

I would like to add a foreign key to my table.

To add to primary key, I click to the column "key" but how can I add a foreign key ?

In the screenshot, the foreign key is on "SER_SYS_ID_SOC" column.

Kinds regards,

Eric.

Re: How can I add a foreign key ?

JohnRMK — Wed, 22 Jul 2020 14:37:18 GMT

Hello,

You cant do it with Talend !

Primary key are possible with talend to perform an update or check the integrity but for the FK or Default constrainte, you must deal that with the DBM

Re: How can I add a foreign key ?

Eric_Talend — Thu, 23 Jul 2020 11:18:36 GMT

Hello,

I feared this answer 😉

Thanks.