I want to create a foreign key in a schema called laboratorio from a table called procedencias to a table called solicitantes.
The problem is that I don't know where to write the name of my schema (laboratorio).
I think it should be in the Target table field but the autocomplete doesn't work for schema. Even I tried writing but doesn't work. I tried this:
- Target tables: laboratorio.solicitantes
- Target tables: "laboratorio"."solicitantes"
But DataGrip can't find the schema.
The error is here: It should be "laboratorio"."solicitantes" (or laboratorio.solicitantes).
Even I tried with PHPStorm. It has the same problem: