Skip to Content
0
Jun 15, 2021 at 01:47 PM

HANA: Constraint on Synonym

115 Views Last edit Jun 15, 2021 at 01:48 PM 2 rev

Dear community,

I set up two hdi containers and connected them via hdbrole, hdbgrants and hdbsynonym.

Now i would like to create a constraint to cascade a delete from one table in the first hdi container to another table in the second hdi container.

my-constraint.hdbconstraint

CONSTRAINT A_CONSTRAINT 
ON MY_TABLE
FOREIGN KEY (FIELD) REFERENCES MY_SYNONYM (FIELD) ON DELETE CASCADE


This results in an error 'table MY_SYNONYM not found' when i use the hdi-deployer.

Do you have any suggestions how i might be able to implement this intra hdi container dependency?

Cheers,

Tobi