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