On Feb 9, 2019, at 8:49 AM, Jose Isaias Cabrera <[email protected]> wrote: > > Perhaps, Dr. Hipp and the team can write a quick PRAGMA that can do something > like this,
You may be interested in the sqldiff program that comes with SQLite: $ sqldiff --help Usage: sqldiff [options] DB1 DB2 Output SQL text that would transform DB1 into DB2. Options: --changeset FILE Write a CHANGESET into FILE -L|--lib LIBRARY Load an SQLite extension library --primarykey Use schema-defined PRIMARY KEYs --rbu Output SQL to create/populate RBU table(s) --schema Show only differences in the schema --summary Show only a summary of the differences --table TAB Show only differences in table TAB --transaction Show SQL output inside a transaction In this case, you want the --table option. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
