Name

writable_schema — Allow modification of system tables

Common Usage

PRAGMA writable_schema;
PRAGMA writable_schema = switch;

Description

The writable_schema pragma gets or sets the ability to modify system tables. If writable_schema is set, tables that start with sqlite_ can be created and modified, including the sqlite_master table.

This pragma makes it possible to corrupt a database using only SQL commands. Be extremely careful when using this pragma.

This is an undocumented pragma.