Documentation Source Text

Check-in [120c7812dd]
Login

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

Overview
Comment:Add the new page_count pragma to pragma.in.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 120c7812dda0a4090402340f4ec84c35a066942f
User & Date: dan 2008-05-16 05:00:14
Context
2008-05-30
18:58
Added Shane's picture and biography to the maintainers page. check-in: c1fc3a9bee user: drh tags: trunk
2008-05-16
05:00
Add the new page_count pragma to pragma.in. check-in: 120c7812dd user: dan tags: trunk
2008-05-14
16:16
Change the release date of 3.5.9 to May 14. check-in: 0b8419d9e2 user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/pragma.in.

615
616
617
618
619
620
621




622
623
624
625
626
627
628
<tcl>Subsection index_list</tcl>
<li><p><b>PRAGMA index_list(</b><i>table-name</i><b>);</b></p>
    <p>For each index on the named table, invoke the callback function
    once with information about that index.  Arguments include the
    index name and a flag to indicate whether or not the index must be
    unique.</p></li>





<tcl>Subsection table_info</tcl>
<li><p><b>PRAGMA table_info(</b><i>table-name</i><b>);</b></p>
    <p>For each column in the named table, invoke the callback function
    once with information about that column, including the column name,
    data type, whether or not the column can be NULL, and the default
    value for the column.</p></li>
</ul>







>
>
>
>







615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
<tcl>Subsection index_list</tcl>
<li><p><b>PRAGMA index_list(</b><i>table-name</i><b>);</b></p>
    <p>For each index on the named table, invoke the callback function
    once with information about that index.  Arguments include the
    index name and a flag to indicate whether or not the index must be
    unique.</p></li>

<tcl>Subsection page_count</tcl>
<li><p><b>PRAGMA &#91;database&#91;.page_count;</b></p>
    <p>Return the total number of pages in the database file.</p></li>

<tcl>Subsection table_info</tcl>
<li><p><b>PRAGMA table_info(</b><i>table-name</i><b>);</b></p>
    <p>For each column in the named table, invoke the callback function
    once with information about that column, including the column name,
    data type, whether or not the column can be NULL, and the default
    value for the column.</p></li>
</ul>