Assign primary key in one DB as foreign key in other DB

Question

A Primary Key column in table A in database One...I want assign it as foreign key in table B in database Two... both DB in same server, I'm using HSQLDB server 2.4 :

A- what would be the query?

B- I saw this way and I read it's not good practice,
Can we use join for two different database tables? two-different-database-tables

is there a better way ?

score 0 · Accepted Answer · answered Feb 08 '18 at 14:10

0

It is not possible with HSQLDB.

You can do this with two different schemas in the same database.

answered Feb 08 '18 at 14:10

fredt

24,044
3
40
61

@fredit...Thanks..will go this way..though no complete separation between schemas(in term od integrity) – Mohd Feb 09 '18 at 05:16

Assign primary key in one DB as foreign key in other DB

1 Answers1