CODEWITHSUNDEEP
databasesqliteandroid-sqlitesqliteopenhelper
Xplosive
Xplosive

Reputation: 681

What sqlite version we use and what is my database file version?

Problem 1: When we creat a sqlite database with sqlite IDE or coding we don’t define sqlite version(1/2/3). So what is the default version and which version we use automatically?

Problem 2: Is there any way to get my current and old sqlite database file version by java coding or something else?

Thanks in advance.

Upvotes: 0

Views: 2812

Answers (1)

laalto
laalto

Reputation: 152927

  1. Android sqlite is sqlite3. The specific version depends on the device and software version.

  2. You can get your schema version with SQLiteDatabase getVersion() in Java code or PRAGMA user_version in SQL.

Upvotes: 1

Related Questions