SQLite Forum

API call instead of PRAGMA schema_version?
Login
Hi,

I can't find such, please let me know if there is one.

(I know I can get it by reading the header at offset 40, which I'd rather not do).

My reasoning is to be able to quickly check for a schema change to invalidate cached information about tables. There would probably be little difference in speed (compared to doing a PRAGMA) but we have sqlite3_table_column_metadata(), why not a sqlite3_schema_version() ?

Thanks,

Paul.