SQLite delete column SQLite delete column sqlite sqlite

SQLite delete column


BEGIN;PRAGMA writable_schema = 1;UPDATE SQLITE_MASTER SET SQL = replace(SQL, '[id] INTEGER NOT NULL PRIMARY KEY**,**', '') WHERE NAME = 'test_table';PRAGMA writable_schema = 0;COMMIT;