SQLite vocabulary: Apprentice level

5 SQLite terms at the Apprentice level, each with a short definition and a link to its full page.

Updated

Study these as flash cards

Dot Commands
Shell commands like .tables and .schema.
In-Memory Database
A database that exists only in memory.
PRAGMA
Statements that read or change SQLite settings.
ROWID
The hidden row number every table has.
Type Affinity
Columns suggest types but don't enforce them.

Every SQLite term, by level