SQLite Forum

Bug: .SCHEMA export sqlite_sequence table
Login

Bug: .SCHEMA export sqlite_sequence table

(1) By anonymous on 2020-10-12 14:16:00 [link]

The `.schema` CLI command exports the `sqlite_sequence` table.

The problem is when the exported file is fed back to the CLI, it complains that this table is only for internal use.  So, manual editing is needed to remove that table definition.

(2.1) By Richard Hipp (drh) on 2020-10-12 14:26:51 edited from 2.0 in reply to 1

Deleted

(3) By Richard Hipp (drh) on 2020-10-12 14:57:27 in reply to 1 [link]

You can now use the new "--nosys" option to the ".schema" command to have it
omit the definitions of system tables like "sqlite_stat1" and
"sqlite_sequence".