Re: [sqlite] modify table (again)

On 7/1/19, Thomas Kurz wrote: > > I really followed the 12-step ALTER TABLE schema and stumbled upon the > following problem: Step 3 and Step 8 need to be modified to also record the content of VIEWs in addition to INDEXes and TRIGGERs. I am working on the revised text now. -- D. Richard Hipp

[sqlite] modify table (again)

Dear all, I really followed the 12-step ALTER TABLE schema and stumbled upon the following problem: PRAGMA foreign_keys=1; CREATE TABLE A (id INTEGER PRIMARY KEY, v1 TEXT, v2 INTEGER); CREATE TABLE B (id INTEGER PRIMARY KEY, ref REFERENCES A(id)); INSERT INTO A (v1, v2) VALUES ('test7', 7);