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 vote257 views1 answer
Mysql group rows with same value
SQL
0 vote280 views1 answer
Synapse sql table set pk
SQL
0 vote266 views1 answer
Renommer schema sql
SQL
27 votes276 views4 answers
Get all tables with column name sql
SQL
0 vote275 views1 answer
Oracle current session details
SQL
0 vote271 views1 answer
How to write triggers to increment or decrement the number of employees
SQL
0 vote274 views1 answer
Creation d'un trigger sql
SQL
5 votes265 views3 answers
How to remove unique key constraint in mysql
SQL
0 vote292 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
1 vote289 views1 answer
Base64 encode sql server
SQL