dotConnect for SQLite Documentation
Devart.Data.SQLite Namespace / SQLiteConnectionStringBuilder Class / WritableSchema Property

WritableSchema Property
Determines whether the SQLITE_MASTER tables can be changed using UPDATE, INSERT, and DELETE statements.
Syntax
'Declaration
 
Public Property WritableSchema As Boolean
 

Property Value

If true - the SQLITE_MASTER tables in which database can be changed using UPDATE, INSERT, and DELETE statements; otherwise they cannot.
Remarks

If this property is specified, the writable_schema SQLite PRAGMA statement is executed when connecting.

Warning: editing SQLITE_MASTER table in such way can result in a corrupt database file.

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also