CODEWITHSUNDEEP
iossqlitecompatibility
Costique
Costique

Reputation: 23722

How to check which features a particular build of SQLite supports?

I'd like to make sure the SQLite library included with iOS 4.0 supports foreign key constraints. The official docs state:

In order to use foreign key constraints in SQLite, the library must be compiled with neither SQLITE_OMIT_FOREIGN_KEY or SQLITE_OMIT_TRIGGER defined.

How can I check it programmatically in C or using sqlite3 CLI tool?

Thanks in advance.

Upvotes: 2

Views: 313

Answers (1)

lawicko
lawicko

Reputation: 7344

The docs say:

sqlite> PRAGMA foreign_keys;
0
sqlite> PRAGMA foreign_keys = ON;
sqlite> PRAGMA foreign_keys;
1
sqlite> PRAGMA foreign_keys = OFF;
sqlite> PRAGMA foreign_keys;
0

Tip: If the command "PRAGMA foreign_keys" 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).

Upvotes: 4

Related Questions