Using SQLite

Name

PRAGMA — Look up or modify an SQLite configuration

Syntax

Common Usage

PRAGMA page_size;
PRAGMA cache_size = 5000;
PRAGMA table_info( table_name );

Description

The PRAGMA command tunes and configures SQLite’s internal components. It is a bit of a catchall command, used to configure or query configuration parameters for both the database engine and database files. It can also be used to query information about a database, such as a list of tables, indexes, column information, and other aspects of the schema.

The PRAGMA command is the only command, outside of SELECT, that may return multiple rows.

Appendix F covers the different PRAGMA commands in detail.

See Also

Appendix F