SQL · Schema and constraints

default

Supplies a value when the insert omits the column.

sqlRunnable example sql course

Syntax

column integer default 0

Example

Open in the lab

CREATE TABLE lessons (
  published INTEGER DEFAULT 0
);
INSERT INTO lessons DEFAULT VALUES;
SELECT published FROM lessons;

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