Adding a default value constraint to a column in SQL

To add a default value to a column in SQL you can do the following

Add default value example

ALTER TABLE table_name
    ALTER COLUMN column NAME
        SET DEFAULT default_value;