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.
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?