The DEFAULT constraint

The syntax when adding the Default constraint in [[The CREATE statement]]:

CREATE TABLE table_name (
column_name data_type DEFAULT default_value
...
);

The syntax when changing the Default constraint in [[The ALTER statement]]:

ALTER TABLE table_name 
ALTER column_name SET DEFAULT default_value;

The syntax when dropping the Default constraint using the [[The DROP statement]]:

ALTER TABLE table_name 
ALTER column_name DROP DEFAULT;