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. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA3-256: |
af6ceab74d3a0524174055f70534d796 |
User & Date: | drh 2017-04-17 18:13:09.219 |
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 | <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 | | > | 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> |
︙ | ︙ |