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.

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

Updated