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: |
120c7812dda0a4090402340f4ec84c35 |
| 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
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 [database[.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>
|