SQL As Understood By SQLite

PRAGMA

The PRAGMA command is a special command used to modify the operation of the SQLite library or to query the library for internal (non-table) data. The PRAGMA command is issued using the same interface as other SQLite commands (e.g. SELECT, INSERT) but is different in the following important respects:

The available pragmas fall into four basic categories:


PRAGMA command syntax

sql-statement ::= PRAGMA name [= value] |
PRAGMA
function(arg)

The pragmas that take an integer value also accept symbolic names. The strings "on", "true", and "yes" are equivalent to 1. The strings "off", "false", and "no" are equivalent to 0. These strings are case- insensitive, and do not require quotes. An unrecognized string will be treated as 1, and will not generate an error. When the value is returned it is as an integer.


Pragmas to modify library operation


Pragmas to query the database schema


Pragmas to query/modify version values


Pragmas to debug the library