SQLite Forum

Feature Request: consistent .dump order
Login
I have a (dangerous) user-space workaround for the `.dump` order requirement:

    CREATE TEMPORARY TABLE _master AS select * from sqlite_master;
    PRAGMA writable_schema=ON;
    DELETE FROM sqlite_master;
    INSERT INTO sqlite_master SELECT * from _master ORDER BY tbl_name,type,name;
    PRAGMA writable_schema=OFF;
    DROP TABLE temp._master;

Running the above before `.dump` seems to do the trick, without having to modify and build from source. Would still be nice to have it by default or as an `--ordered` option to `.dump`.