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 vote365 views1 answer
Get date from timestamp in mysql
SQL
2 votes347 views1 answer
Add 2 hours to current time in MySQL
SQL
0 vote346 views1 answer
How to get initials in sql
SQL
23 votes358 views3 answers
Mysqldump
SQL
0 vote331 views1 answer
Create domain sql
SQL
0 vote327 views1 answer
Oracle create package body
SQL
3 votes362 views1 answer
Start mysql server by terminal in linux
SQL
0 vote337 views1 answer
Changer un mot de passe mysql
SQL
0 vote357 views1 answer
How many rows affected in sqllite
SQL
3 votes346 views4 answers
Mysql delete duplicate rows
SQL