What is DEFAULT constraint ?

The DEFAULT constraint provides a default value to a column when the INSERT INTO statement does not

provide a specific value.

 

Syntax:

 

CREATE TABLE table_name

(

 column1 datatype Unique,

 column1 datatype,

 column1 datatype DEFAULT default_vaule

);