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 |