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 a
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;
sqlite>
2 matches
Mail list logo