What Is DEFAULT Constraint in SQL ? – The Code Hubs

What Is DEFAULT Constraint in SQL ?

Nishant Kakadiya Jul 18, 2022 0 234

Forums › SQL › What Is DEFAULT Constraint in SQL ?

0 Vote Up Vote Down

Nishant Kakadiya

Staff asked 2 years ago

Answers (1)

Add Answer

0 Vote Up Vote Down

Hit Sutariya

Staff answered 2 years ago

The 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

Example:

ALTER TABLE Persons
ALTER City SET DEFAULT ‘Surat’;