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] [source]

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 [link] [source]

Deleted

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

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".