Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Mention that the argument to pragma table_info can be a view. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
63eb2d26233aa4cafe975eb11b7c3a03 |
| 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
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>
|