What can you say about SQLite supporting foreign keys?

devquora
devquora

Posted On: Feb 22, 2018

 

As of the latest version, SQLite supports foreign key constraints. But the enforcement of the foreign key constraints is turned off by default (backward compatibility).
In order to enable foreign key constraint enforcement, run PRAGMA foreign_keys=ON command or you can also compile with DSQLITE_DEFAULT_FOREIGN_KEYS=1.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    SQLite interview questions

    What is SQLite and where is it used?

    The SQLite is mostly ACID (Atomicity, Consistency, Isolation, and Durability) compliant relational database management ..

    SQLite interview questions

    Distinguish between SQLite and SQL?

    SQLite: It is a well built, embedded relational database management system that is mostly used in mobile devices for da..

    SQLite interview questions

    Mention some SQLite commands and also explain them?

    The SQLite commands interact directly with relational databases and are similar to SQL. Below are the standard SQLite c..