How to find SQLITE database file version

Question

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 1

Check manual file

sqlite3.version The version number of this module, as a string. This is not the version of the SQLite library.

sqlite3.version_info The version number of this module, as a tuple of integers. This is not the version of the SQLite library.

sqlite3.sqlite_version The version number of the run-time SQLite library, as a string.

sqlite3.sqlite_version_info The version number of the run-time SQLite library, as a tuple of integers.

Answer 2

You can get version number of a database file by the Magic Header String:

• sqlite2 ==> first 48 bytes
• sqlite3 ==> first 16 bytes

---

$ head -c 48 file2.db
** This file contains an SQLite 2.1 database **

$ head -c 16 file3.db
SQLite format 3

---

The easier way is using the file command:

$ file file2.db
file2.db: SQLite 2.x database

$ file file3.db
file3.db: SQLite 3.x database

Answer 3

If you have a data connection to it in Visual Studio, you can right click on the data base in Server Explorer, select properties, and the version will be shown in the properties window, (under Version, surprisingly). You might need to left click the database first to open it.

Answer 4

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

select sqlite_version();

Answer 5

Get user_version: run sql: PRAGMA user_version;

Get schema_version: PRAGMA schema_version;

When create database file (.db), user_version can be set by user.

Answer 6

The correct answer from version 3 is:

sqlite3 --version