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

In This Topic
    WritableSchema Property
    In This Topic
    Determines whether the SQLITE_MASTER tables can be changed using UPDATE, INSERT, and DELETE statements.
    Syntax
    'Declaration
     
    Public Property WritableSchema As Boolean
    public bool WritableSchema {get; set;}

    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