Documentation Source Text

       <br>PRAGMA </b><i>database</i><b>.secure_delete =
               </b><i>boolean</i></p>
    <p>Query or change the secure-delete setting.)^ ^When secure-delete
    on, SQLite overwrites deleted content with zeros.  ^The default
    setting is determined by the [SQLITE_SECURE_DELETE]
    compile-time option.

    <p>
    ^This pragma sets or clears the secure-delete flag when the pragma is
    prepared, not when the resulting prepared statement is run.  ^The
    prepared statement for this pragma merely returns the value of the
    secure-delete setting at the time the statement was prepared.  One should
    not retain or reuse the prepared statement for this pragma.

    <p>
    ^When there are [ATTACH | attached databases] and no database
    is specified in the pragma, all databases have their secure-delete
    setting altered and the return value is the value of the main database.
    ^The secure-delete setting for newly attached databases is the setting
    of the main database at the time the ATTACH command is evaluated.

    <p>
    ^When multiple database connections share the same cache, changing
    the secure-delete flag on one database connection changes it for them
    all.