writableSchema

Queries or sets the writable_schema flag, which allows direct modification of the internal schema tables (like sqlite_schema).

Warning: This is a very dangerous pragma and should almost never be used. Modifying the schema tables directly can easily lead to database corruption.

When this pragma is enabled (true), the sqlite_schema table becomes writable, allowing INSERT, UPDATE, and DELETE operations. This is typically only used by tools like VACUUM or for repairing a corrupt database. When disabled (false, the default), any attempt to modify the schema table will fail.

The writable_schema is automatically reset to false after each transaction commit.

See also