On delete set default

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 "

Source: sqlservertutorial.net

Similar codes

1 vote150 views4 answers
Get week day from date in sql
SQL
1 vote142 views1 answer
Group_concat max length mysql
SQL
0 vote147 views1 answer
Pl/sql loop example
SQL
0 vote144 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
2 votes160 views1 answer
Mysql time ago difference
SQL
0 vote161 views1 answer
Sql select column name like from multiple tables
SQL
0 vote144 views1 answer
Change permission to database mysql
SQL
0 vote142 views1 answer
Mysql calculated column
SQL
0 vote151 views1 answer
Pl/ sql change currency
SQL
0 vote147 views1 answer
How to use sqlcommand
SQL