| OLD | NEW |
| 1 | 1 |
| 2 OVERVIEW | 2 OVERVIEW |
| 3 | 3 |
| 4 The SQLite library is capable of parsing SQL foreign key constraints | 4 The SQLite library is capable of parsing SQL foreign key constraints |
| 5 supplied as part of CREATE TABLE statements, but it does not actually | 5 supplied as part of CREATE TABLE statements, but it does not actually |
| 6 implement them. However, most of the features of foreign keys may be | 6 implement them. However, most of the features of foreign keys may be |
| 7 implemented using SQL triggers, which SQLite does support. This text | 7 implemented using SQL triggers, which SQLite does support. This text |
| 8 file describes a feature of the SQLite shell tool (sqlite3) that | 8 file describes a feature of the SQLite shell tool (sqlite3) that |
| 9 extracts foreign key definitions from an existing SQLite database and | 9 extracts foreign key definitions from an existing SQLite database and |
| 10 creates the set of CREATE TRIGGER statements required to implement | 10 creates the set of CREATE TRIGGER statements required to implement |
| (...skipping 117 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
| 128 in the same way as the results of SELECT queries are. Normally, this means | 128 in the same way as the results of SELECT queries are. Normally, this means |
| 129 they will be printed to stdout, but this can be configured using other | 129 they will be printed to stdout, but this can be configured using other |
| 130 dot-commands (i.e. ".output"). | 130 dot-commands (i.e. ".output"). |
| 131 | 131 |
| 132 The simplest way to activate the foriegn key definitions in a database | 132 The simplest way to activate the foriegn key definitions in a database |
| 133 is simply to open it using the shell tool and enter the command | 133 is simply to open it using the shell tool and enter the command |
| 134 ".genfkey --exec": | 134 ".genfkey --exec": |
| 135 | 135 |
| 136 sqlite> .genfkey --exec | 136 sqlite> .genfkey --exec |
| 137 | 137 |
| OLD | NEW |