3 ms·
While we can get the information on the columns used in a view, we can't infer if the uniqueness properties propagate to the view which guarantee the semantics
by 0x777 10y ago
While we can get the information on the columns used in a view, we can't infer if the uniqueness properties propagate to the view which guarantee the semantics of relationships.
I guess it might be convenient to do this (determine relationships across views), but the users should be aware of the guarantees offered in this scenario.
- ruslan_talpa 10y agoI am not sure i understand what you are saying about guarantees. If there is a FK, there is a relation. It's the user that is driving the relations by specifying what columns are FK, it's the same thing as defining relations in a GUI, only you do it at the database level