DEFAULT Constraint

The DEFAULT Constraint is used to insert the default values into a column during design time.

The default values is used in new record if no value is specified during INSERT Statement.

The default

SQL DEFAULT Constraint Syntax

CREATE TABLE table_name ( column_name1 data_type DEFAULT Value, column_name2 data_type DEFAULT Value, column_name3 data_type DEFAULT Value, .... )

Example