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

13 votes164 views3 answers
Uninstall mysql centos 7
SQL
1 vote206 views1 answer
Insert pg result of select
SQL
6 votes142 views5 answers
Get current date sql
SQL
0 vote150 views1 answer
Mysql find db contarint
SQL
12 votes159 views1 answer
Docker run mysql image
SQL
4 votes209 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
0 vote156 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
7 votes192 views1 answer
Show line number in sql server
SQL
10 votes153 views5 answers
Create table mysql query
SQL
0 vote115 views1 answer
Oracle function select into
SQL