Documentation Source Text
Check-in [9523519a73]
Not logged in

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
SHA1 Hash:9523519a73fad290e1fca261e1e83191c37a19ae
Date: 2010-02-13 15:43:27
User: drh
Comment:Correction to the PRAGMA secure_delete documentation.
Tags And Properties
Changes
hide diffs unified diffs patch

Changes to pages/pragma.in

639 <br>PRAGMA </b><i>database</i><b>.secure_delete = 639 <br>PRAGMA </b><i>database</i><b>.secure_delete = 640 </b><i>boolean</i></p> 640 </b><i>boolean</i></p> 641 <p>Query or change the secure-delete setting.)^ ^When secure-delete 641 <p>Query or change the secure-delete setting.)^ ^When secure-delete 642 on, SQLite overwrites deleted content with zeros. ^The default 642 on, SQLite overwrites deleted content with zeros. ^The default 643 setting is determined by the [SQLITE_SECURE_DELETE] 643 setting is determined by the [SQLITE_SECURE_DELETE] 644 compile-time option. 644 compile-time option. 645 645 646 <p> < 647 ^This pragma sets or clears the secure-delete flag when the pragma is < 648 prepared, not when the resulting prepared statement is run. ^The < 649 prepared statement for this pragma merely returns the value of the < 650 secure-delete setting at the time the statement was prepared. One should < 651 not retain or reuse the prepared statement for this pragma. < 652 < 653 <p> 646 <p> 654 ^When there are [ATTACH | attached databases] and no database 647 ^When there are [ATTACH | attached databases] and no database 655 is specified in the pragma, all databases have their secure-delete 648 is specified in the pragma, all databases have their secure-delete 656 setting altered and the return value is the value of the main database. | 649 setting altered. 657 ^The secure-delete setting for newly attached databases is the setting 650 ^The secure-delete setting for newly attached databases is the setting 658 of the main database at the time the ATTACH command is evaluated. 651 of the main database at the time the ATTACH command is evaluated. 659 652 660 <p> 653 <p> 661 ^When multiple database connections share the same cache, changing 654 ^When multiple database connections share the same cache, changing 662 the secure-delete flag on one database connection changes it for them 655 the secure-delete flag on one database connection changes it for them 663 all. 656 all.