There's nothing in the file itself apart from the schema format number of 1-4.
If you want to get a "version valid for" sort of thing you'd have to scan http://www.sqlite.org/changes.html for non-backwards compatible features, then scan the schema in sqlite_master for those. For example... -If you see a partial index you would know 3.8.0+ -"without rowid" you could say the database needed version 3.8.2+ -Index on an expression: 3.9.0+ You'd also have to look for things in triggers, views etc like row values (3.15.0+) etc. It'd probably be a pain to implement. If you try to open a database with a feature from the future you get some sort of "not a database" error, or something. -----Original Message----- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Igor Korot Sent: Friday, July 21, 2017 10:57 AM To: Discussion of SQLite Database Subject: [sqlite] Database version Hi, ALL, Is there a way to know the version of the .db file I am using? I'd like to issue some kind of SELECT statement to get it. Looks like there is an interface to get the library version, but I don't see anything for a db file. Thank you. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
