c# - SQLite 删除列

Question

我使用此代码形式重命名列或其他:

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

但是我不能删除:

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

此代码我知道:) 不要提供。

BEGIN TRANSACTION;
CREATE TEMPORARY TABLE t1_backup(a,b);
INSERT INTO t1_backup SELECT a,b FROM t1;
DROP TABLE t1;
CREATE TABLE t1(a,b);
INSERT INTO t1 SELECT a,b FROM t1_backup;
DROP TABLE t1_backup;
COMMIT;

编辑:我找到了!

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;

Answer 1

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;