ON DELETE SET DEFAULT
SQL Server sets the rows in the child table to their default values
if the corresponding rows in the parent table are deleted.
To execute this action, the foreign key columns must have default definitions.
"Note that: a nullable column has a default value of (NULL)
if no default value specified "