Create a WITHOUT ROWID table

sql

CREATE TABLE locale_strings (
  locale TEXT NOT NULL,
  key TEXT NOT NULL,
  value TEXT NOT NULL,
  PRIMARY KEY (locale, key)
) WITHOUT ROWID;

Explanation

Useful when the natural primary key is composite and rowid storage adds little value.

Learn the surrounding workflow

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

Same sheet · prioritizing Create tables and constraints

Define a rowid-backed table with primary key and timestamps.

Open In sheetsqlsame section

Validate allowed values at the database layer.

Open In sheetsqlsame section

Reference a parent table from a child table.

Open In sheetsqlsame section

Materialize or compute a derived value from another column.

Open In sheetsqlsame section

Append a new nullable or defaulted column.

Open In sheetsql1 tag match

Change the table name without recreating data.

Open In sheetsql1 tag match