How to find SQLITE database file version

Srikanth S picture Srikanth S · Mar 10, 2012 · Viewed 93.7k times · Source

I have few sqlite database files. I want to know the database file version i.e if the database was created with sqlite2 or sqlite3 or any other main/sub version (not the sqlite library or driver or user_version or schema_version).

Answer

saurabh picture saurabh · Jan 15, 2014

You can write this command in any sqlite explorer which will give the sqlite version

select sqlite_version();