Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add documentation for the collation_list pragma. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
db4897a3ddaabec32e9c171bc7bc5bc4 |
| User & Date: | drh 2009-04-06 18:51:03 |
Context
|
2009-04-09
| ||
| 21:23 | Begin updating the website for version 3.6.13. check-in: d781fa0569 user: drh tags: trunk | |
|
2009-04-07
| ||
| 18:34 | Merge two leaves. check-in: 17aaeb85f9 user: dan tags: trunk | |
|
2009-04-06
| ||
| 18:51 | Add documentation for the collation_list pragma. check-in: db4897a3dd user: drh tags: trunk | |
| 16:42 | Updates to the PRAGMA documentation. check-in: a84577d9a2 user: drh tags: trunk | |
Changes
Changes to pages/pragma.in.
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
...
700
701
702
703
704
705
706
707
708
709
710
711
712
713
|
<tcl>Section {Pragmas to modify library operation} modify</tcl>
</tcl>
<ul>
<tcl>Subsection auto_vacuum</tcl>
<li><p><b>PRAGMA auto_vacuum;<br>
PRAGMA auto_vacuum = </b><i>boolean</i><b>;</b></p>
<p>Query or set the auto-vacuum status in the database.</p>
<p>The default setting for auto-vacuum is 0 or "none",
unless the [SQLITE_DEFAULT_AUTOVACUUM] compile-time option is used.
The "none" setting means that auto-vacuum is disabled.
When auto-vacuum is disabled and data is deleted data from a database,
................................................................................
here. In that sense, this pragma is only advisory.</p>
</li>
</ul>
<tcl>Section {Pragmas to query the database schema} schema</tcl>
<ul>
<tcl>Subsection database_list</tcl>
<li><p><b>PRAGMA database_list;</b></p>
<p>For each open database, invoke the callback function once with
information about that database. Arguments include the index and
the name the database was attached with. The first row will be for
the main database. The second row will be for the database used to
store temporary tables.</p></li>
|
|
>
>
>
>
>
>
|
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
...
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
|
<tcl>Section {Pragmas to modify library operation} modify</tcl>
</tcl>
<ul>
<tcl>Subsection auto_vacuum</tcl>
<li><p><b>PRAGMA auto_vacuum;<br>
PRAGMA auto_vacuum = </b>
<i>0 | NONE | 1 | FULL | 2 | INCREMENTAL</i><b>;</b></p>
<p>Query or set the auto-vacuum status in the database.</p>
<p>The default setting for auto-vacuum is 0 or "none",
unless the [SQLITE_DEFAULT_AUTOVACUUM] compile-time option is used.
The "none" setting means that auto-vacuum is disabled.
When auto-vacuum is disabled and data is deleted data from a database,
................................................................................
here. In that sense, this pragma is only advisory.</p>
</li>
</ul>
<tcl>Section {Pragmas to query the database schema} schema</tcl>
<ul>
<tcl>Subsection collation_list</tcl>
<li><p><b>PRAGMA collation_list;</b></p>
<p>Return a list of the collating sequences defined for the current
database connection.</p></li>
<tcl>Subsection database_list</tcl>
<li><p><b>PRAGMA database_list;</b></p>
<p>For each open database, invoke the callback function once with
information about that database. Arguments include the index and
the name the database was attached with. The first row will be for
the main database. The second row will be for the database used to
store temporary tables.</p></li>
|