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

3 votes347 views1 answer
Postgresql if null then 0
SQL
0 vote316 views1 answer
Original Query
SQL
0 vote339 views1 answer
Oracle for loop on list
SQL
0 vote312 views1 answer
IS THEre any difference between using default and := in plsql
SQL
1 vote339 views1 answer
Random name function in mysql for nvarchar
SQL
0 vote325 views1 answer
Mysql update even / odd rows
SQL
0 vote340 views1 answer
Sql common columns
SQL
0 vote327 views1 answer
What is between keyword used for
SQL
79 votes592 views6 answers
Grepper code
SQL
4 votes318 views2 answers
Sql table
SQL