Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Update the documentation on the foreign_key_check pragma to explain that the second output column is NULL for WITHOUT ROWID child tables. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
af6ceab74d3a0524174055f70534d796 |
| User & Date: | drh 2017-04-17 18:13:09 |
Context
|
2017-04-18
| ||
| 11:07 | Update the perfomance and size spreadsheet with the latest figures. check-in: 7b34966b61 user: drh tags: trunk | |
|
2017-04-17
| ||
| 18:13 | Update the documentation on the foreign_key_check pragma to explain that the second output column is NULL for WITHOUT ROWID child tables. check-in: af6ceab74d user: drh tags: trunk | |
|
2017-04-13
| ||
| 09:59 | Update fts5 docs to reflect support for a user column on the LHS of a MATCH operator. check-in: ab263df2e6 user: dan tags: trunk | |
Changes
Changes to pages/pragma.in.
1359 1360 1361 1362 1363 1364 1365 1366 1367 1368 1369 1370 1371 1372 1373 |
<p>^(The foreign_key_check pragma checks the database, or the table
called "<i>table-name</i>", for
[foreign key constraints] that are violated and returns one row of
output for each violation.)^ ^There are four columns in each result row.
^The first column is the name of the table that contains the REFERENCES
clause. ^The second column is the [rowid] of the row that
contains the invalid REFERENCES clause. ^The third column is the name
of the table that is referred to. ^The fourth column is the index of
the specific foreign key constraint that failed. ^The fourth column
in the output of the foreign_key_check pragma is the same integer as
the first column in the output of the [foreign_key_list pragma].
^(When a "<i>table-name</i>" is specified, the only foreign key constraints
checked are those created by REFERENCES clauses in the
CREATE TABLE statement for <i>table-name</i>.)^</p>
|
| > |
1359 1360 1361 1362 1363 1364 1365 1366 1367 1368 1369 1370 1371 1372 1373 1374 |
<p>^(The foreign_key_check pragma checks the database, or the table
called "<i>table-name</i>", for
[foreign key constraints] that are violated and returns one row of
output for each violation.)^ ^There are four columns in each result row.
^The first column is the name of the table that contains the REFERENCES
clause. ^The second column is the [rowid] of the row that
contains the invalid REFERENCES clause, or NULL if the child table is a
[WITHOUT ROWID] table. ^The third column is the name
of the table that is referred to. ^The fourth column is the index of
the specific foreign key constraint that failed. ^The fourth column
in the output of the foreign_key_check pragma is the same integer as
the first column in the output of the [foreign_key_list pragma].
^(When a "<i>table-name</i>" is specified, the only foreign key constraints
checked are those created by REFERENCES clauses in the
CREATE TABLE statement for <i>table-name</i>.)^</p>
|