The command .dump ?TABLE? Render database content as SQL creates scripts such as

CREATE TABLE IF NOT EXISTS "1980-1982_F" ...

and the SQL for populating the table as

INSERT INTO "1980-1982_F" VALUES(.....)

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

• INSERT INTO omits the enumeration of field names i.e. (f1,...,fn)
• The table is not dropped

Wish:

• EITHER DROP TABLE IF EXISTS "1980-1982_F" followed by CREATE TABLE "1980-1982_F" ...
• OR the (enumeration of columns) after INSERT INTO

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