SQLite Forum

SQL to return list of PRAGMAs
Login
> Can I get this list using SQL?

Not just like that. You'll have to write a script/program that executes the pragmas you are interested in against your database, and compare the outcome with the outcome of the same script run against a "default database".

Something like:

```shell
for p in $(cat relevant_pragmas) ; do printf ".print %s::\nPRAGMA %s;\n" "$p" "$p" ; done | sqlite3 default.sqlite >pragma0.txt
for p in $(cat relevant_pragmas) ; do printf ".print %s::\nPRAGMA %s;\n" "$p" "$p" ; done | sqlite3  yourdb.sqlite >pragma1.txt
diff -u pragma0.txt pragma1.txt
```

~~~
-- 
Regards,
Kees
~~~