SQL DEFAULT Constraint

The SQL DEFAULT constraint is used to set a default value for a column.

The default value will be added to all new records, if no other value is specified.

The syntax for a DEFAULT key command is as follows −

CREATE TABLE Persons (
    ID int NOT NULL,
    LastName varchar(255) NOT NULL,
    FirstName varchar(255),
    Age int,
    City varchar(255) DEFAULT 'Sandnes'
);