SQLite Forum

.dump
Login
The command
<b>.dump ?TABLE?            Render database content as SQL</b>
creates scripts such as

<i>CREATE TABLE IF NOT EXISTS "1980-1982_F" ...</i>

and the SQL for populating the table as 

<i>INSERT INTO "1980-1982_F" VALUES(.....)</i>

If I want to revert to the version at the time I created the script, the script will fail when I've added a column to the table because<ul><li><i>INSERT INTO </i> omits the enumeration of field names i.e. (f1,...,fn)</li><li>The table is not dropped</li></ul>

Wish:
<ul><li>EITHER <i>DROP TABLE IF EXISTS "1980-1982_F" </i> followed by <i>CREATE TABLE "1980-1982_F" ... </i><li>OR the (enumeration of columns) after <i>INSERT INTO</i></li></ul>

Perhaps another argument to select DROP before CREATE OR INSERT (... Field enumeration...)?