On 8/7/18, Mark Wagner <[email protected]> wrote: > 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. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
