SQL DEFAULT Constraint : add Default Value Into a Column
The DEFAULT constraint is used to set a default value for a column. In the below example City column has the default value Sandnes CREATE TABLE Persons ( ID int NOT NULL, LastName varchar(255) NOT NULL, FirstName varchar(255), Age int, City varchar(255) DEFAULT ‘Sandnes’); The default value will be added to all new records if no other value is specified. Example of default constraint Example … Read more