SQLite Forum

SQLDIFF to Import
Login
It is an interesting question as to whether the sqlite_sequence table should be generated by sqldiff output. I think it is arguably correct and arguably incorrect.

If you want the same result as if that explicit sqlite_sequence creation was absent, you can use the SQLite shell's .dump command in this way:<code>
  sqlite3 -batch -cmd ".dump" testit.sdb > testit_dump.sql < nul
</code>, where 'testit.sdb' is your template database (and using the equivalent of the null device on your system for 'nul'.)