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

1 vote183 views1 answer
Database Queries
SQL
0 vote193 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL
0 vote212 views1 answer
Except in sql
SQL
1 vote202 views1 answer
Mysql column start with string
SQL
16 votes190 views1 answer
Sqlserver add column to table
SQL
0 vote188 views3 answers
Get free card roblox
SQL
0 vote176 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
0 vote206 views1 answer
Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens
SQL
23 votes192 views4 answers
How to show all users in mysql
SQL
3 votes213 views1 answer
Oracle list privileges
SQL