Comment on It's not you, it's SQLparentComments−dragonwriter3yThere’s no way to express data structure knowledge in sql, only relations and keys.Relations, keys, and (though you forgot them) constraints express…quite a lot of data structure knowledge.And every time I want to join table A to B I have to re-define everything, because SQL doesn’t store that.SQL stores that if you tell it to; the usual way being view CREATE VIEW.
Comments
Relations, keys, and (though you forgot them) constraints express…quite a lot of data structure knowledge.
SQL stores that if you tell it to; the usual way being view CREATE VIEW.