On Feb 9, 2019, at 8:49 AM, Jose Isaias Cabrera <jic...@outlook.com> 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
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to