Menu
I wanted to use foreign key mechanism for database. But, the tables are not following the integrity constraints. How can I be sure that, my sqlite3 db has Foreign key support ?
630
SQLite has supported foreign key constraint since version 3.6. 19. The SQLite library must also be compiled with neither SQLITE_OMIT_FOREIGN_KEY nor SQLITE_OMIT_TRIGGER. To check whether your current version of SQLite supports foreign key constraints or not, you use the following command.
A table can have multiple foreign keys based on the requirement.
A foreign key is a way to enforce referential integrity within your SQLite database. A foreign key means that values in one table must also appear in another table. The referenced table is called the parent table while the table with the foreign key is called the child table.
Type the command "PRAGMA foreign_keys" in the sqlite3 prompt and if returns no data instead of a single row containing "0" or "1", then the version of SQLite you are using does not support foreign keys (either because it is older than 3.6.19 or because it was compiled with SQLITE_OMIT_FOREIGN_KEY or SQLITE_OMIT_TRIGGER defined)
More info is available in the link below: http://www.sqlite.org/foreignkeys.html
179
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
