Define default constraint.- These constraints are a special case of column defaults.
- It provides a default value to a column when the INSERT INTO statement does not provide a specific value.
- Default constraint is used to fill a column with default value defined during creation of table if nothing is supplied while inserting data.
- IDENTITY columns and timestamp columns cannot be associated with default constraint.
- It is used to insert a default value into a column.
|