Re: [sqlite] After column add, what should be done to update the schema?

On 2/27/20 7:03 PM, Andy KU7T wrote: Hi, I use a simple ALTER TABLE ADD COLUMN statement. However, when I use the Sqlite Expert, the DDL is not reflected. One thing to be aware of is that when SQLite adds the column, it often doesn't format it like you'd expect. For example: CREATE TABLE

[sqlite] sqldiff does not report foreign key constraint differences

The "Limitations" section of the sqldiff documentation mentions it doesn't handle triggers or views, but nothing about constraints. So I expected this to report something (note how in db1, t3.ref refences t1; in db2, it references t2): sqlite> .open db1 sqlite> pragma foreign_keys = 1;