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.
Get Using SQLite now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.