Documentation Source Text

All files named "pages/foreignkeys.in"
Login

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

History for pages/foreignkeys.in

2024-01-23
13:07
[a8733ccf86] part of check-in [5eef8cf0b5] Add a note to foreignkeys.in that fk references may not span schemas. (check-in: [5eef8cf0b5] user: stephan branch: trunk, size: 40674)
2022-01-20
21:38
[65cb8c8c4c] part of check-in [96d1781d44] Grammar improvements where noted by https://sqlite.org/forum/forumpost/6712173dd2 (check-in: [96d1781d44] user: larrybr branch: trunk, size: 40438)
2021-02-28
18:41
[d5bd5119e4] part of check-in [d9df475a24] Typo fix, plural to possessive. (check-in: [d9df475a24] user: larrybr branch: trunk, size: 40433)
2020-06-19
13:05
[c3cb2df161] part of check-in [29b01bac87] Create a new documentation page devoted to describing the use and purpose of the sqlite_schema table. Work-in-progress. (check-in: [29b01bac87] user: drh branch: trunk, size: 40432)
2020-06-18
21:18
[6147a2ea61] part of check-in [e01d8c6144] Terminology adjustments. (check-in: [e01d8c6144] user: drh branch: trunk, size: 40430)
2017-07-03
11:01
[3a828dc742] part of check-in [58cb4dd691] Fix a typo in the FOREIGN KEY documentation. (check-in: [58cb4dd691] user: drh branch: branch-3.19, size: 40430)
2016-09-14
18:40
[39e13f90f4] part of check-in [858d993381] Add and use the "[dateof:3.X.Y]" hyperlink target for automatically inserting release dates into the text. (check-in: [858d993381] user: drh branch: trunk, size: 40437)
2016-08-20
17:22
[ffdae5dc99] part of check-in [9d49a78f9b] Add "jump to" links to relevant sections of large documents in search results. (check-in: [9d49a78f9b] user: dan branch: experimental, size: 40393)
2014-04-25
20:46
[faed810a82] part of check-in [2de942054f] Fix more typos in the foreignkey.html document. (check-in: [2de942054f] user: drh branch: trunk, size: 40381)
20:23
[c72f8966e9] part of check-in [821750714a] Fix a typo in the foreign key documentation. (check-in: [821750714a] user: drh branch: trunk, size: 40389)
2013-08-23
01:57
[2717514315] part of check-in [8e16497ef1] Add documentation for the query_only and defer_foreign_keys pragmas. Update the change log for the 3.8.0 release. (check-in: [8e16497ef1] user: drh branch: trunk, size: 40404)
2010-11-18
16:21
[293568ea3c] part of check-in [d1edb27943] Update the documentation to be explicit that a parent key must not be a rowid. (check-in: [d1edb27943] user: drh branch: trunk, size: 40251)
2010-08-04
12:03
[8458d9b482] part of check-in [5b960cc498] Fix a broken hyperlink from lang_conflict.html to foreignkeys.html. (check-in: [5b960cc498] user: drh branch: trunk, size: 40154)
2010-01-21
06:06
[8ea1ddd4ae] part of check-in [7889bfe143] Change foreignkeys.in to be more similar to other documentation files. (check-in: [7889bfe143] user: dan branch: trunk, size: 40128)
2009-10-21
13:44
[dde7f75197] part of check-in [00a66e6757] Fix a typo in the foreign key documentation. (This changes on requirement number.) Identify new requirements in SQL function implementations. (check-in: [00a66e6757] user: drh branch: trunk, size: 39951)
2009-10-13
01:03
[64add9caa0] part of check-in [f91582d301] Tweaks to composite foreign key documentation. (check-in: [f91582d301] user: drh branch: trunk, size: 39950)
2009-10-12
17:56
[0d27432811] part of check-in [a6630ea9bd] Additional updates, improvements, and corrections to section 3 of the foreignkeys.html document. (check-in: [a6630ea9bd] user: drh branch: trunk, size: 39917)
15:28
[a3d7718150] part of check-in [87ab34e6a7] Fix a bug in the way the matrix generator script computes requirement numbers using MD5 - remove surplus spaces before running MD5 over the text. Also check-in some updates to the foreignkeys.html document. (check-in: [87ab34e6a7] user: drh branch: trunk, size: 38866)
14:02
[b66f9a8cee] part of check-in [74815839cd] Fix a comma-splice in a sentence in the foreignkey.html document. (check-in: [74815839cd] user: drh branch: trunk, size: 38443)
13:57
[7f23b87c46] part of check-in [a20a86f146] Fix another typo in the same SQL example of foreignkeys.html (check-in: [a20a86f146] user: drh branch: trunk, size: 38447)
13:54
[130ffd0f5a] part of check-in [768c8f120d] Add a missing semicolon to an SQL example in foreignkeys.html (check-in: [768c8f120d] user: drh branch: trunk, size: 38447)
2009-10-10
14:48
[f0585da449] part of check-in [de5e4731cd] Tweaks to the foreign key documentation. (check-in: [de5e4731cd] user: drh branch: trunk, size: 38443)
14:34
[4350470df9] part of check-in [7e3189adf2] Add a missing word to foreignkeys.html. (check-in: [7e3189adf2] user: dan branch: trunk, size: 38250)
14:28
[432b423194] part of check-in [6dd77467c3] Minor rewording of the foreignkeys.html document. Some requirements changed. Update the testcase evidence scanner to better handle evidence comments in TCL scripts. (check-in: [6dd77467c3] user: drh branch: trunk, size: 38247)
2009-10-09
17:22
[0f0b15516b] part of check-in [3677b8fc81] Remove an incorrect sentence from foreignkeys.html. (check-in: [3677b8fc81] user: dan branch: trunk, size: 38234)
13:33
[5ca8779875] part of check-in [fe28facf39] Updates to Omitted Features. Add fragments to the foreign key document. Other documentation tweaks. (check-in: [fe28facf39] user: drh branch: trunk, size: 38283)
13:30
[6a4ee7d5a9] part of check-in [de78ea29fa] Remove an incorrect paragraph from foreignkeys.in. Fix a few other small details. (check-in: [de78ea29fa] user: dan branch: trunk, size: 38115)
2009-10-08
11:19
[f6468de799] part of check-in [70b1eab895] Use ^( instead of ^ on a sentence in foreignkeys.in. (check-in: [70b1eab895] user: dan branch: trunk, size: 38538)
2009-10-07
18:43
[8bc6bb508c] part of check-in [90c2bee863] Fix a sentence in foreignkeys.in. (check-in: [90c2bee863] user: dan branch: trunk, size: 38487)
10:45
[b934b27d26] part of check-in [52421d8609] Update the description of the "PRAGMA count_changes" command to describe the way changes made by foreign key actions are handled. (check-in: [52421d8609] user: dan branch: trunk, size: 38488)
00:31
[af39879cfb] part of check-in [cc6bec4374] Update SQL language and foreign key documentation to better identify testable statements of truth about foreign keys. (check-in: [cc6bec4374] user: drh branch: trunk, size: 38487)
2009-10-06
19:04
[a2141d1260] part of check-in [9e64626f1d] Updates matrix building scripts to ignore "." contained within markup. (check-in: [9e64626f1d] user: drh branch: trunk, size: 38255)
11:59
[27233f5a38] part of check-in [912746a5f1] Begin making changes that allow requirements text to be extracted directly from HTML documentation files. (check-in: [912746a5f1] user: drh branch: trunk, size: 37866)
2009-09-29
05:52
[e950db6191] part of check-in [f21e45d5b6] Update foreignkeys.html to explain the changes to DROP and ALTER TABLE, and to remove the comments on the "immediate-immediate" constraint problem. (check-in: [f21e45d5b6] user: dan branch: trunk, size: 37724)
2009-09-25
04:35
[ee0cbf7910] part of check-in [1c76780f1c] Fix the mismatched tags problem identified by [2cda06fa85]. (check-in: [1c76780f1c] user: dan branch: trunk, size: 34623)
2009-09-23
09:19
[44c36dffd4] part of check-in [cb8c404c1e] Add a comment to foreignkeys.html to make it clear that an ON UPDATE action is only performed if the parent key values modified so that the new values are distinct from the old. (check-in: [cb8c404c1e] user: dan branch: trunk, size: 34624)
2009-09-22
15:32
[d350d37ece] part of check-in [bdfaef8a63] Add documentation for the foreign_keys pragma. Fix broken hyperlinks in the new foreign key constraints document. (check-in: [bdfaef8a63] user: drh branch: trunk, size: 33360)
12:30
[27c841f030] part of check-in [02d2a1296b] Extra details in the foreign keys document. (check-in: [02d2a1296b] user: dan branch: trunk, size: 33352)
10:34
[240f013b73] part of check-in [3f9fde89b3] Enhance foreign key support page. (check-in: [3f9fde89b3] user: dan branch: trunk, size: 28154)
2009-09-21
19:07
[92e2fba1e4] part of check-in [a636d1d50b] Add an example of an index on a child key to foreignkeys.in. (check-in: [a636d1d50b] user: dan branch: trunk, size: 18005)
15:29
Added: [083ebad3ee] part of check-in [639baca342] Add partially finished document "foreignkeys.in". (check-in: [639baca342] user: dan branch: trunk, size: 17366)