Documentation Source Text

Check-in [63eb2d2623]
Login

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

Overview
Comment:Mention that the argument to pragma table_info can be a view.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 63eb2d26233aa4cafe975eb11b7c3a03a30ed209
User & Date: drh 2014-08-12 22:47:06
Context
2014-08-13
18:53
Updates to the webserver source code. check-in: 1c4aeae543 user: drh tags: trunk
2014-08-12
22:47
Mention that the argument to pragma table_info can be a view. check-in: 63eb2d2623 user: drh tags: trunk
02:49
Updates to the "How SQLite Is Tested" document. check-in: 7aa17891ac user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/pragma.in.

1165
1166
1167
1168
1169
1170
1171

1172
1173
1174
1175
1176
1177
1178
    <p>This pragma returns one row for each column in the named table.)^
    ^Columns in the result set include the column name,
    data type, whether or not the column can be NULL, and the default
    value for the column.  ^The "pk" column in the result set is zero
    for columns that are not part of the primary key, and is the index of
    the column in the primary key for columns that are part of the primary
    key.</p>

}

Pragma {schema_version user_version} {
    <p><b>PRAGMA schema_version; 
       <br>PRAGMA schema_version = </b><i>integer </i><b>;
       <br>PRAGMA user_version;
       <br>PRAGMA user_version = </b><i>integer </i><b>;</b>







>







1165
1166
1167
1168
1169
1170
1171
1172
1173
1174
1175
1176
1177
1178
1179
    <p>This pragma returns one row for each column in the named table.)^
    ^Columns in the result set include the column name,
    data type, whether or not the column can be NULL, and the default
    value for the column.  ^The "pk" column in the result set is zero
    for columns that are not part of the primary key, and is the index of
    the column in the primary key for columns that are part of the primary
    key.</p>
    <p>^The table named in the table_info pragma can also be a view.</p>
}

Pragma {schema_version user_version} {
    <p><b>PRAGMA schema_version; 
       <br>PRAGMA schema_version = </b><i>integer </i><b>;
       <br>PRAGMA user_version;
       <br>PRAGMA user_version = </b><i>integer </i><b>;</b>