> I was surprised to see sqldiff --schema not report column constraints as
> schema differences. Or am I missing something?
> $ echo .schema | sqlite3 /tmp/f1.db
> CREATE TABLE t (foo text unique);
> $ echo .schema | sqlite3 /tmp/f2.db
> CREATE TABLE t (foo text);
> $ sqldiff --schema /tmp/f1.db /tmp/f2.db
Correct. sqldiff appears to only look at the column names, not constraints.
I think it will pick up if you add an extra UNIQUE index.