如何查找 SQLITE 数据库文件版本

You can extract the information from the header file. It will require you to open the database file 'by hand' but I don't know if there is an API function to get this information.

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

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.

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

select sqlite_version();

I found this to be the easiest method to determine the version of sqlite. Run the Python IDLE Shell, then do the following:

>>> import sqlite3
>>> sqlite3.version
'2.6.0'

In my case it was 2.6.0. Hope this helps... Mark

The correct answer from version 3 of sqlite program is:

sqlite3 --version

You have to open the python shell then write these steps:

import sqlite3


sqlite3.sqlite_version

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.

Get user_version

Run SQL: PRAGMA user_version;

Get schema_version:

Run SQL: PRAGMA schema_version;

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

In command prompt, if you type sqlite3 and hit enter, it will automatically give the version number at the very first.

sqlite3