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 vote361 views1 answer
Mysql root permission denied lost
SQL
0 vote361 views1 answer
SQL loop with cursor
SQL
0 vote398 views1 answer
Date 3 months from today sql
SQL
0 vote299 views1 answer
Copy table dbeaver
SQL
1 vote353 views2 answers
Mysql join two tables
SQL
0 vote485 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
0 vote370 views1 answer
Get db connection detail from sql developer profile
SQL
1 vote346 views1 answer
Sql get all columns from one table but one from another inner join
SQL
7 votes369 views2 answers
Oracle sql drop index
SQL
0 vote355 views1 answer
Install sql server windows 10
SQL