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
Get Using SQLite now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
