SQL · Schema and constraints

alter table

Changes an existing table. Some databases require a table rewrite for certain changes.

sqlRunnable example sql course

Syntax

alter table name add column …

Example

Open in the lab

CREATE TABLE lessons (title TEXT);
ALTER TABLE lessons ADD COLUMN minutes INTEGER DEFAULT 0;
SELECT minutes FROM lessons;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.