Documentation Source Text

Check-in [af6ceab74d]
Login

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: af6ceab74d3a0524174055f70534d7968877c66f882868c881b64520a91d28d6
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
Unified Diff Ignore Whitespace Patch
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>