Documentation Source Text

Check-in [db4897a3dd]
Login

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

Overview
Comment:Add documentation for the collation_list pragma.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: db4897a3ddaabec32e9c171bc7bc5bc48337a2c1
User & Date: drh 2009-04-06 18:51:03.000
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
Unified Diff Ignore Whitespace Patch
Changes to pages/pragma.in.
︙︙
94
95
96
97
98
99
100
101

102
103
104
105
106
107
108


<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,








|
>








94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109


<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,
︙︙
700
701
702
703
704
705
706





707
708
709
710
711
712
713

    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>








>
>
>
>
>








701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719

    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>
︙︙