3 ms·
> What do you think should happen if there are multiple foreign keys connecting the two tables? Compilation should fail and require you to explicitly specify w
by Aeolun 4y ago
> What do you think should happen if there are multiple foreign keys connecting the two tables?
Compilation should fail and require you to explicitly specify what key to use. Please don’t do anything magic.
- setr 4y agoYou can’t add an additional foreign key to an existing table without potentially breaking all existing queries. Probably the biggest constraint SQL language design has is that its on a live system — things are not compiled at the same time.