3 ms·
Foreign keys exist for data integrity... something which is rather opaque to query onterface... So why do you believe that has place in a query?
by unbanned 5y ago
Foreign keys exist for data integrity... something which is rather opaque to query onterface... So why do you believe that has place in a query?
- JoelJacobson 5y agoForeign keys both define relationships between tables, and also enforce referential integrity. The discussion is about how we could potentially mine various additional value from foreign keys as an information resource, rather than just mostly being about referential integrity.
- cryptonector 5y agoWhy do you think it's opaque? They declare relations between tables. That's structure, intent. Making intent clearer is generally a good thing.