Add a column

sql

ALTER TABLE users ADD COLUMN timezone TEXT;

Explanation

Adding a column is easy, but more complex schema changes often require a table rebuild.

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 Change schemas safely

Change the table name without recreating data.

Open In sheetsqlsame section

Adjust a column name in-place.

Open In sheetsqlsame section

Canonical pattern for dropping constraints or changing types.

Open In sheetsqlsame section

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

Open In sheetsql1 tag match

Validate allowed values at the database layer.

Open In sheetsql1 tag match

Reference a parent table from a child table.

Open In sheetsql1 tag match