3 ms·
>If you extended the meta-powers, you could create/delete tables by inserting into/deleting from the “tables table”, and similarly add/remove/alter columns by m
by lambdatronics 6y ago
>If you extended the meta-powers, you could create/delete tables by inserting into/deleting from the “tables table”, and similarly add/remove/alter columns by manipulating the “columns table”. Your schema then becomes data, and your power has become a super-power. I don’t know if any DB has implemented this, or if the advantages would be really compelling over normal DDL.
That's interesting. Has anyone heard of such a meta-relational database?
- dragonwriter 6y ago> Has anyone heard of such a meta-relational database? Schema-as-data is a central part of the relational model, and is implemented (usually with some limitations) in most RDBMSs. OTOH, DDL manipulation is usually more convenient than DML against catalog tables, even when you can in theory acheive the same result either way.