DEFAULT Constraint
The DEFAULT constraint provides a default value for a column when no value is specified.
Example: Using DEFAULT Constraint
CREATE TABLE Cities (
CityID INT PRIMARY KEY,
CityName VARCHAR(50),
Population INT DEFAULT 100000
);Explanation: If no population value is provided, the Population column will default to 100,000.