Re: [sqlite] Usefulness of FKs to multiple tables

Jean-Christophe Deschamps wrote: > Let me ask this by mere curiosity. > > SQLite will accept and process the following: > > CREATE TABLE x (a CHAR PRIMARY KEY); > CREATE TABLE y (a CHAR PRIMARY KEY); > CREATE TABLE z (a CHAR REFERENCES x(a) REFERENCES y(a)); > > I didn't check if the last FK is

[sqlite] Usefulness of FKs to multiple tables

Let me ask this by mere curiosity. SQLite will accept and process the following: CREATE TABLE x (a CHAR PRIMARY KEY); CREATE TABLE y (a CHAR PRIMARY KEY); CREATE TABLE z (a CHAR REFERENCES x(a) REFERENCES y(a)); I didn't check if the last FK is even valid normative SQL and that isn't the heart