Cheat Sheet logoCheat Sheet Today
SQLite DDL and Schema Design Cheatsheet/Create a generated column

Materialize or compute a derived value from another column.

Back to sheetBrowse commands
Sign in to save
Section: Create tables and constraints

Create a generated column

sql
sql
CREATE TABLE events (
  id INTEGER PRIMARY KEY,
  payload TEXT NOT NULL,
  event_type TEXT GENERATED ALWAYS AS (json_extract(payload, '$.type')) STORED
);
Explanation

Generated columns are handy with JSON payloads and can be indexed when stored.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing Create tables and constraints
Create a basic table
Define a rowid-backed table with primary key and timestamps.
OpenIn sheetsqlsame section
Use a CHECK constraint
Validate allowed values at the database layer.
OpenIn sheetsqlsame section
Add a foreign key
Reference a parent table from a child table.
OpenIn sheetsqlsame section
Create a WITHOUT ROWID table
Optimize some composite-key tables.
OpenIn sheetsqlsame section
Add a column
Append a new nullable or defaulted column.
OpenIn sheetsql1 tag match
Rename a table
Change the table name without recreating data.
OpenIn sheetsql1 tag match