# PRAGMA

*noun*

say it: **“PRAG-muh”** **/ˈpræɡmə/**

A SQLite command that reads or changes one of the database's settings, such as PRAGMA foreign_keys = ON.

## What is **PRAGMA**?

`PRAGMA` statements read or change SQLite settings, like turning on foreign key checks.

```sql
PRAGMA foreign_keys = ON;
PRAGMA journal_mode = WAL;
```

## In a sentence

- “**PRAGMA** user_version holds the number of the last migration that ran.”
- “The connection runs **PRAGMA** foreign_keys = ON first, or SQLite ignores foreign keys.”

Level: Apprentice · [More SQLite terms at this level](https://www.ask-codey.com/glossary?category=sqlite&level=2)

Updated: November 19, 2026

Source: https://www.ask-codey.com/glossary/pragma
