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

0 vote146 views1 answer
Sql track modification
SQL
0 vote133 views1 answer
Parsing float to int in mysql
SQL
0 vote138 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
0 vote151 views1 answer
Is not numeric sql
SQL
0 vote165 views1 answer
Mysql command line top 10
SQL
1 vote143 views1 answer
Display total number of tables in mysql
SQL
1 vote137 views1 answer
Sqlite check if row exists
SQL
0 vote135 views1 answer
Find usage of table in sql server
SQL
0 vote272 views1 answer
Multiple row join
SQL
3 votes143 views2 answers
Get current year sql
SQL