On 5/5/16, Simon Slavin <slavins at bigfraud.org> wrote: > > On 5 May 2016, at 5:15pm, Cecil Westerhof <cldwesterhof at gmail.com> wrote: > >> I know how to get the version of the running version of SQLite, but is >> there a way to get the version with which the database was created? > > One often finds three version numbers stored: > > A) The version of the engine which was used to create the file. > B) The earliest version of the engine which has made changes to the file. > C) The latest version of the engine which has made changes to the file. > > I don't think SQLite stores any of these.
SQLite stores the version number of the last writer in the database header. There is no PRAGMA to retrieve this, but you can see it by running the ".dbinfo" command in the shell. -- D. Richard Hipp drh at sqlite.org
