SQLite | SQLite Functions | Query SQLite Version Information (sqlite_version Function)

Tags:

• SQLite
• Database

You can use the sqlite_version function to check the SQLite version information that is currently running. This article explains how to use the sqlite_version function.

How to Use the sqlite_version Function

The sqlite_version function returns the version information of the running SQLite. The format is as follows.

sqlite_version()

It returns a string representing the SQLite version.

–

Now, let us try it.

select sqlite_version();

sqlite> .mode column
sqlite> .header on
sqlite> 
sqlite> select sqlite_version();
sqlite_version()
----------------
3.19.3          
sqlite> 

The SQLite version has been queried.

In addition to the sqlite_version function, you can also check the version with a command.

sqlite> .version
SQLite 3.19.3 2017-06-27 16:48:08 2b0954060fe10d6de6d479287dd88890f1bef6cc1beca11bc6cdb79f72e2377b

This shows more detailed build information than the function.